dbDelta – will it work?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Ron Rennick

    (@wpmuguru)

    10 years, 9 months ago

    dbDelta relies on SHOW TABLES; so it will not work with any sharded DB structures. For situations where dbDElta is used you need to write your own scripts to perform the SQL commands on the appropriate databases.

    Thread Starter meglio

    (@meglio)

    10 years, 9 months ago

    So it means that dbDelta will work well only in situations when additional plugin tables do not depend on blog id – because it will always run on the main database. Right?

    Plugin Author Ron Rennick

    (@wpmuguru)

    10 years, 9 months ago

    because it will always run on the main database. Right?

    You can’t rely on the last selected database being the global one.

    Thread Starter meglio

    (@meglio)

    10 years, 9 months ago

    Do you happen to have any solution that you can share?

    Plugin Author Ron Rennick

    (@wpmuguru)

    10 years, 9 months ago

    Do you happen to have any solution that you can share?

    I did above:

    For situations where dbDelta is used you need to write your own scripts to perform the SQL commands on the appropriate databases.

    For example: http://wpmututorials.com/news/mu-2-9-beta/

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘dbDelta – will it work?’ is closed to new replies.

Tags