how to copy a database

[sfullman]

Hi, this is kind of an important one.

At work (as opposed to home where i use Linux), we run mysql on a Novell Netware server. The way the tables and data are stored is entirely different than Linux. In Linux, each database is a folder; copy the folder to a new name, and you've just basically cloned the database.

However, we can't find the data on the Novell system. Yes, each database has a folder, and in it are a bunch of .frm files, but they are all only about 9KB, and apparently only declare the table structure. There are a bunch of binary files in the folder above which look from the date stamps like they store the data.

Could anyone help on this? Sincerely, Sam Fullman

[Pig]

An easy way to copy a database, or back it up, or whatever is to do a dump using a database utility. MySQL Front, MySQL Control Center, and phpmyadmin are all good programs and can dump the data into a .sql file.

To create a new database from the dump, simply run the .sql tab using the same software.