Chris, I have found that using the mysqldump command and directing the output to a file was the best way to do a backup. You get one file that contains all tables. You can use tar and gzip on it to reduce the file size. Additonally it is in ASCII so can be read with any editor. To Reload you just drop/create your database then run the file as input to the mysql command: example: mysql <database name> < file1.backup There are some options to the mysqldump that will even drop/create the db for you as part of the load I believe though have not used it that way. If you do that then drop the db name out of the mysql command above. This method is release independent since it uses mySQL to create the db. Regards, Robert Friedrichshafen, Germany On Sun, 28 Apr 2002, Chris wrote:
Hi,
What files do you need to backup in suse mysql databases? how then do you restore those databases regardless what suse mysql version is running?
chris