Web Hosting Talk







View Full Version : Simple mySql question


WingZero
07-10-2002, 02:20 PM
When I want to dump the tables and create a .sql backup in phpmyadmin, what options should I choose? The checkbox options are
-Add 'drop table'
-Complete inserts
-Extended inserts
-Use backquotes with tables and fields' names

Also, should I choose
-structure only
or
-data only
or
-structure and data

Thanks!

RRolfe
07-10-2002, 02:36 PM
complete inserts and structure and data

D8Mike
07-10-2002, 02:59 PM
login to phpMyAdmin

Click your username at the top so that it shows all your tables.

Find : View dump (schema) of database

Select what your wish to backup by clicking one of the three circles :

Structure only
Structure and data < - * Thats what id Choose *
Data only

Then tick : Save as file

then press " Go "

and your backing up your database.