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.
[edit]
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
[edit]
Using graphical tools
Somebody has to fill this ...


