Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2007
    Location
    Mount Maunganui, New Zealand
    Posts
    419
    Plugin Contributions
    0

    Default 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!

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Backing up with phpMyAdmin 3.4.2

    Check it and see what the quick does or dosen't do
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Jan 2007
    Location
    Mount Maunganui, New Zealand
    Posts
    419
    Plugin Contributions
    0

    Default 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?

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default 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
    Code:
    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 ;
    Zen-Venom Get Bitten

 

 

Similar Threads

  1. Replies: 4
    Last Post: 12 Dec 2014, 06:02 PM
  2. Backing up with Filezilla?
    By strugglingnovice in forum General Questions
    Replies: 9
    Last Post: 25 Jul 2011, 09:54 AM
  3. Backing up the database using phpMYADMIN
    By Sevenhelmets in forum General Questions
    Replies: 4
    Last Post: 2 Feb 2010, 03:28 PM
  4. Backing up with CPanel
    By QueenKat in forum General Questions
    Replies: 12
    Last Post: 30 Apr 2007, 08:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg