Hi



I have been trying to figure out a command to issue an SQL dump with:

Dump to file

Dump all tables

Write CREATE TABLE statements

Selected..

My server will not accept the command on the browser and I have to issue it on Telnet or SSH..



Help is really wanted..

Thanks
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory

The general ideas is in this command;

mysqldump -uusername -ppassword database_name > /home/dumps/backup.sql

There is a whole page of documentation available at http://www.mysql.com/doc/m/y/mysqldump.html, which includes the extra options you may want to use.

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Remember what was mentioned the other day, you don't want to put the password in the main command ;)

Thanks both
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory

Hmm that reply was directed at Andy...not sure why I ended up replying to you :(

Anyway what I meant was:

mysqldump -uUSERNAME -p database > /path/to/file.txt

....then you enter your password afterwards.