Backing up with phpMyAdmin 3.4.2

Results 1 to 4 of 4

14 Jun 2011, 18:16

mcpisik

Zen Follower

Join Date:: Jan 2007
Posts:: 417
Plugin Contributions:: 0

Backing up with phpMyAdmin 3.4.2

Hi,
I've always used phpmyadmin to backup.
Only extra tick I've put is the Add drop table.
Others have been default.

New version 3.4.2 has a new layout and the option for..
Quick-display only the minimal options, or
Custom

Do I need to keep going in and selecting Add drop table?
Or can I just do a quick backup...
Thanks!

14 Jun 2011, 18:39

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Backing up with phpMyAdmin 3.4.2

Check it and see what the quick does or dosen't do

14 Jun 2011, 18:50

mcpisik

Zen Follower

Join Date:: Jan 2007
Posts:: 417
Plugin Contributions:: 0

Re: Backing up with phpMyAdmin 3.4.2

Yeah I tried it, but didn't show me any selections. Just saves it to a folder.
So I have a sql file, but is there a way to know if its suitable for use later as a backup?

14 Jun 2011, 19:18

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Backing up with phpMyAdmin 3.4.2

You can inspect the file but guess if you do not know or can not determine what type of backup it generates that you select Custom

One

DROP TABLE IF EXISTS `address_book`;
CREATE TABLE IF NOT EXISTS `address_book` (
  `address_book_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `entry_gender` char(1) NOT NULL default '',
  `entry_company` varchar(64) default NULL,
  `entry_firstname` varchar(32) NOT NULL default '',
  `entry_lastname` varchar(32) NOT NULL default '',
  `entry_street_address` varchar(64) NOT NULL default '',
  `entry_suburb` varchar(32) default NULL,
  `entry_postcode` varchar(10) NOT NULL default '',
  `entry_city` varchar(32) NOT NULL default '',
  `entry_state` varchar(32) default NULL,
  `entry_country_id` int(11) NOT NULL default '0',
  `entry_zone_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`address_book_id`),
  KEY `idx_address_book_customers_id_zen` (`customers_id`)
) ENGINE=MyISAM  AUTO_INCREMENT=10 ;