Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010
    Location
    Australia
    Posts
    231
    Plugin Contributions
    0

    Default export / import Db using phpmyadmin

    I've been using phpmyadmin to backup my database, as I'm making a lot of changes.

    If I make a mistake and need to restore the database with an earlier version, I assume I need to use the 'import' function for the same database in phpmyadmin.

    My question is, will this overwrite all the existing data and restore the database as it was before, or will it just insert the new database entries?

    I noted that the recommended setting for the DB export is "insert".... don't know if that is relevant or not.

    Thanks a lot!

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

    Default Re: export / import Db using phpmyadmin

    If you follow the tutorial, you will set "drop" table so an import restorews it to what ever content exists in rhe backup

    https://www.zen-cart.com/tutorials/i...hp?article=103
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Jul 2010
    Location
    Australia
    Posts
    231
    Plugin Contributions
    0

    Default Re: export / import Db using phpmyadmin

    Fantastic, I've been using the setting they recommend there, so i should be fine

    Thank you!

 

 

Similar Threads

  1. Export/import in phpmyadmin
    By Unicorn in forum General Questions
    Replies: 4
    Last Post: 29 Jul 2010, 12:04 PM
  2. Import data using phpMyAdmin
    By JohnBoyCR in forum General Questions
    Replies: 2
    Last Post: 14 Feb 2009, 06:48 PM
  3. Export to excel using PHPMyAdmin?
    By chris parker in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 12 Mar 2008, 09:43 PM
  4. phpMyAdmin/mySQL data export problem
    By isaacr25 in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 13 Nov 2007, 05:45 AM
  5. phpMyAdmin database tables export/import for categories ect. help
    By oxicottin in forum Installing on a Windows Server
    Replies: 0
    Last Post: 2 Sep 2007, 10:46 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