Mysql table prefix

luisgzafraluisgzafra
edited April 2012 in General
Hello, i want to use this script with a table prefix on mysql. For example, the table avatar like 1_avatar.

how can i made it?

Sorry for the expression, but I'm Spanish and do not speak English very well :)

Comments

  • lnxwaltlnxwalt
    Since you cannot share a database with another application, prefixes are not needed. See http://gitorious.org/statusnet/mainline/blobs/master/INSTALL

    "Note that StatusNet must have its own database; you can't share the database with another program. You can name it whatever you want, though."
  • luisgzafraluisgzafra
    I need this, because i want to develop a multisite with status.net script.

    I'm editting the script to get it :D with the var $__table in each class is easy make it.
  • lnxwaltlnxwalt
    If you're doing a multisite, why not have separate databases? You could name the databases subdomain_ name_statusnet. (For instance, site1.yoursite.com could use a database named site1_statusnet, while site2.yoursite.com could use site2_statusnet as its database.)

    That way, you have less risk of database corruption and a less confusing situation to manage.
  • luisgzafraluisgzafra
    I like the idea :)

    I'll try to do so.

    Tanks!! ;)
  • airstandairstand
    For more security you can change database prefixes. I have do that for http://highsol.net :)
  • luisgzafraluisgzafra
    @airstand How did you do?

    I see in the classes $ __table without any prefix integrated.
  • lnxwaltlnxwalt
    @airstand For more security? I fail to see how using prefixes vs multiple databases increases security. All I can see is that it decreases reliability. Care to explain?
  • airstandairstand
    I do it with bash script, but I need some time to publish it.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Google Sign In with OpenID
Sign In Register

Categories