Gossamer Forum: General: Databases and SQL: Backup Specific Table...

Aug 11, 2003, 3:21 PM

Andy

Veteran / Moderator (18441 posts)

Aug 11, 2003, 3:21 PM

Post #1 of 3

Shortcut

Backup Specific Table...

Hi. I'm trying to figure out how to backup a specific table in a tabase. I have tried multiple ideas, including;

mysqldump -u****** -p**** --tables=lsql_Links LINKS > backup_file.sql

Does anyone have any examples of --tables being used? I can't find any useful site on Google. Even the official site doesn't have an example of it being used...just some tech jargon which went right over my head).

Any help is much appreciated :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 11, 2003, 3:52 PM

Stealth

Veteran (17240 posts)

Aug 11, 2003, 3:52 PM

Post #2 of 3

Shortcut

Re: [Andy] Backup Specific Table... In reply to

Have you tried the following?

Code:
mysqldump -u****** -p**** LINKS lsql_Links > backup_file.sql

Basically using DBName Table
========================================
Buh Bye!

Cheers,
Me

Aug 12, 2003, 3:35 AM

Andy

Veteran / Moderator (18441 posts)

Aug 12, 2003, 3:35 AM

Post #3 of 3

Shortcut

Re: [Stealth] Backup Specific Table... In reply to

Hi. I tried;

mysqldump -u**** -p*** LINKS lsql_Links > test.sql &

... but it just puts a dead value into test.sql.

Any ideas?

Cheers

Andy (mod)
andy@ultranerds.co.uk