hosted by sflogo.jpg

Conversion of MySQL database

From Bibus

When upgrading bibus, you may have to upgrade your database. It is the case between 1.3 and 1.4.

Using the command line

You must first extract your data from your old database (old_db) and save them in a file (data.sql):

>> mysqldump -xt -u root -p old_db > data.sql

Now create a new database (new_db) using the model in bibus/db_model:

>> mysql -u root -p -e "create database new_db"

>> mysql -u root -p new_db < db_models/mysql_41.sql

Now, put back your old data in your newly created database:

>> mysql -u root -p new_db < data.sql

Using graphical tools

Somebody has to fill this ...

Personal tools