Page 1 of 1
structure backup
Posted: Tue Jul 24, 2007 8:43 pm
by m2babaey
Hi
I went to a database and decided to export it ( get backup in phpmyadmin)
but it was a huge database (133meg)
how can i backup only the structure?
thanks
Posted: Tue Jul 24, 2007 9:15 pm
by boo
There should be a checkbox that you can uncheck that say data.
Doing this should only backup to structure of the database not the data
Posted: Tue Jul 24, 2007 9:56 pm
by m2babaey
and I noticed just one of its tables is very big
( over 660000 records)
can I ask to backup data too but limit that table to 200 records?
Posted: Tue Jul 24, 2007 10:57 pm
by superdezign
m2babaey wrote:and I noticed just one of its tables is very big
( over 660000 records)
can I ask to backup data too but limit that table to 200 records?
That hardly sounds like a backup to me. Try writing a little script that backs up your database into a file, and set up a cronjob to call it daily. phpMyAdmin has too many restrictions.