Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: allan on November 03, 2002, 09:28:42 AM

Title: where does the mysql database hide ?
Post by: allan on November 03, 2002, 09:28:42 AM

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.

Title: Re: where does the mysql database hide ?
Post by: Arkman on November 03, 2002, 06:57:48 PM

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.

Title: Re: where does the mysql database hide ?
Post by: allan on November 04, 2002, 12:03:11 PM

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

Title: Re: where does the mysql database hide ?
Post by: Byte on November 04, 2002, 01:02:15 PM

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