|
How do I back up a specific range of records?
My database has become too large to back up using the backup in Nuke or under phpmyadmin. I need to trim my nuke_stories table but even it's too large to backup normally (it's 4.1meg). What is the mysql command that I can use in phpmyadmin to create a backup of a specific range of records in a table. I figure I can create several backups of, say, records 1-100, 101-200, etc. and then start trimming the old ones. Thanks in advance.
|