Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Command to do the dump?

Quote Reply
Command to do the dump?
Thanks TheStone for my previous question...

Here is another one.

I have database with about 20 megs of data, and I am trying to do the dump through the phpmyadmin or mysql, but it just hangs after about 30 mins...
"timed out" I tried to change the setting for script time value, but eventually my browser quits...

What is the command to execute this either telnet or dos window? If I click mysql.exe, it takes me to mysql command prompt? Is this ok?

I would like to dump the table named address, and not the whole db?

And how about ssl command to get that table on my live server? db named customers and table stays same address?
Quote Reply
Re: [Suomi] Command to do the dump? In reply to
Hi,

Run mysqldump.exe to get a list of options. If you only want the schema, and not data, you can do:

mysqldump --add-drop-table --no-data databasename > schema.txt

and it will put the output into a file schema.txt. To insert that on another server you would just do:

mysql databasename < schema.txt

(that will drop any existing tables of the same name!).

Cheers,

Alex
--
Gossamer Threads Inc.