Web Hosting Talk







View Full Version : MySQL Backup and restore?


sitekeeper
08-19-2001, 11:09 PM
I thought all the data from a Vbulletin board was stored in a MySql database in /var/lib/mysql/vbulletin or what ever name you use? I was testing a backup and restore of a test install of Vbulletin. I deleted all the files from /var/lib/mysql/vbulletin. I figured Vbulletin would no longer work, but it works fine and I can still add posts. :confused:

Where else would the data be stored? What was all the files (*.MYI, *.MYD) that I deleted in the var/lib/mysql/vbulletin dir? All other MySQL databases are working fine.

Any Ideas?

BOB :homer:

bombino
08-20-2001, 09:11 PM
You should never directly delete mySQL Database files. You can get rid of the database by using the 'drop database' command.

# mysql -u root -p
mysql> drop database 'vbulletin';
mysql> quit;
#

sitekeeper
08-21-2001, 10:09 AM
Originally posted by bombino
You should never directly delete mySQL Database files. You can get rid of the database by using the 'drop database' command.

I wasn't trying to delete the database I was testing a backup and restore. I deleted the files figuring that the Vbulletin board would not work then I would restore the files from a backup.

But the Vbulletin board never quit working, that was what my question was about.

Why did the Vbulletin board still work, where else was it's data stored????

BOB :D

jnestor
08-21-2001, 02:12 PM
Stop and restart MySQL and see if it's still working. MySQL may have everything cached already.

sitekeeper
08-21-2001, 04:11 PM
Originally posted by jnestor
Stop and restart MySQL and see if it's still working. MySQL may have everything cached already.

I never would of thought of that, you were right!

Thanks
BOB :beer: