Topic: where does the mysql database hide ?

[allan]

Howdy folks, I have 5.5 running a treat, i've installed postnke and have it just right .. now I want to pull the whole lot down and upgrade the server .. I've backed up e-smith, but where is my rogue database hidden ? I've backed it up through myphpadmin, but where will i re-install it to when the system is back up and running ?

cheers,
al.

[Arkman]

You have two options here:

1. If you use the SME backup and then restore it on your new system the nuke database, and any others, will be restored onto the new server.

2. If you used phpmyadmin to do the backup use the option to include 'inserts'. Then when you have things installed again use phpmyadmin to  run the backup file and create the database again.

[allan]

Thanks, I'll rest easy knowing I can upgrade away !
al.

[Byte]

Or you can find all the database's which are stored in

/var/lib/mysql

that is where all the different database's are

hope this helps



Byte