Can mySQL generate scripts for me?

[mendhak]

Currently, I've got mySQL on my laptop, and I have one particular table in which I have pre-determined values.

Now, I want to be able to enter these values onto the mySQL database on my web server.

I don't want to have to manually enter the values, as that would take forever, since there are about 110 fields I want to enter.

Can mySQL generate a SQL script for me to do this? Or is there some other method for accomplishing this?

TIA

[mendhak]

*FROGBUMP*

[phpman]

use phpmyadmin to make a backup in a sql file. or you can use mysqldump() at the command prompt or you can go into mysql/bin/winmysqladmin.exe and do it there.

[mendhak]

Originally posted by phpman
use phpmyadmin to make a backup in a sql file. or you can use mysqldump() at the command prompt or you can go into mysql/bin/winmysqladmin.exe and do it there.

I spent about 20 minutes trying various combinations with mysqldump at the mysql> command prompt. :aargh:

Finally, I had the brains to go back to c:/mysql/bin> and try it


mysqldump -u username -p password datbasename > "anyfile.sql"

[adnanqaizar]

someone just copy and paste the code