Hot to export a MySQL DB.

[Arc]

How would i go about exporting a MySQL DB into any format. Preferably a format that i can import into another program like Excel.

What i really want to do is export a MySQL DB into excel as an excel document. But i will settle for just exporting the DB.

[pete_bisby]

Creating an Excel spreadsheet via PHP has been covered in previous posts here, but when I tried it it never seemed to work correctly.

You could always create a comma-separated file, which can be read by all (or a good majority) of databases. Use the fopen/fwrite/fclose commands to create the file.

[talkster5]

also dont use excel its not good enough to make proper databases use microsoft access its a much more powerful program and easier and quicker to make databases