structure backup

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
m2babaey
Forum Contributor
Posts: 364
Joined: Sun May 20, 2007 9:26 am

structure backup

Post 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
User avatar
boo
Forum Commoner
Posts: 42
Joined: Mon Jul 02, 2007 11:30 am
Location: NY

Post 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
m2babaey
Forum Contributor
Posts: 364
Joined: Sun May 20, 2007 9:26 am

Post 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?
User avatar
superdezign
DevNet Master
Posts: 4135
Joined: Sat Jan 20, 2007 11:06 pm

Post 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.
Post Reply