dump and insert

[dethfire]

What is the command to dump the database structure, data and zip it?

Also what is the command to execute the sql file to the db?

[Toly]

For backing up:

mysqldump -u username -p db_name | gzip > backup.sql.gz

For restoring:

mysql -u username -p db_name < backup.sql

[dethfire]

For backing up:

mysqldump -u username -p db_name | gzip > backup.sql.gz

For restoring:

mysql -u username -p db_name < backup.sql

how do you restore from the zip? also is this the best way to transfer large databases? say like a gig?

[Toly]

how do you restore from the zip? also is this the best way to transfer large databases? say like a gig?

You can use winzip to extract the file. And for the second question, as far as I know, that is the best method.