View Single Post
How do I back up a specific range of records?
Old
  (#1 (permalink))
jmellicant
Junior Member
 
Status: Offline
Posts: 12
Join Date: Dec 2002
How do I back up a specific range of records? - 03-11-2003, 10:34 AM

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.
   
Reply With Quote