Exporting/backup Help

[Kanng]

Alright so I don't want to backup the WHOLE table only a single row, I've been looking around for the right SQL statement to do so I tried this:

BACKUP FROM `abcdefg` WHERE `entry` BETWEEN #### AND ####;

but after a few tries I concluded that it either was wrong syntax or that statement didn't exist….

So am I right or wrong? is there a correct SQL statement to do that? or does it even exist?

Please help me out.

Best Regards and Thanks,

Kanng

[navyashree.r]

Kanng wrote on May 29 2009, 05:23 AM:

Alright so I don't want to backup the WHOLE table only a single row, I've been looking around for the right SQL statement to do so I tried this:

BACKUP FROM `abcdefg` WHERE `entry` BETWEEN #### AND ####;

Hi,

To backup a single row from a table you can use the below SQL query by giving the exact path where to Backup.

Quote:

“SELECT ….. INTO OUTFILE”

For example,

“SELECT * FROM Table1 where column1 between #### AND #### INTO OUTFILE 'E:Test.SQL';”

FYI,

http://dev.mysql.com/doc/refman/5.1/en/select.html#id3854478

Regards,

Navya

[Kanng]

navyashree.r wrote on May 28 2009, 08:06 PM:

Hi,

To backup a single row from a table you can use the below SQL query by giving the exact path where to Backup.

For example,

“SELECT * FROM Table1 where column1 between #### AND #### INTO OUTFILE 'E:Test.SQL';”

FYI,

http://dev.mysql.com/doc/refman/5.1/en/select.html#id3854478

Regards,

Navya

Alright cool thank you!

[peterlaursen]

The characters must be escaped so correct is

“SELECT * FROM Table1 where column1 between #### AND #### INTO OUTFILE 'E:\Test.SQL';”

(Windows file paths are a litle inconvenient in MySQL)

[Author]

Posts