Results 1 to 9 of 9

Threaded View

  1. #1
    Join Date
    Nov 2006
    Posts
    512
    Plugin Contributions
    0

    Default Import local backup into new database

    I need to import data from a local backup into a new database.

    I created a new MySQL database and new name for it. Unfortunately I did not enable drop table, when I backed up my old database.

    When I try to import my old data into a new database, it errors out and states that database exists already. (my old database is still up, but I do not want to delete or merge due to some changes)


    I have my local backup as a .sql file which I downloaded with phpmyadmin, with these settings: see jpeg

    and I also have a .txt file from a telnet/SSH dump but it also contains my old database name.

    any advice?
    Attached Images Attached Images  

 

 

Similar Threads

  1. v153 Getting Database into new v.1.5.3 using Backup My Sql
    By NWCE in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 5 Aug 2014, 02:24 PM
  2. import 1.3.8 database into new install 1.3.9h
    By vwebworld in forum Upgrading from 1.3.x to 1.3.9
    Replies: 4
    Last Post: 5 Aug 2011, 10:49 AM
  3. Import customer details only into database
    By mcpisik in forum General Questions
    Replies: 6
    Last Post: 28 Dec 2010, 05:48 PM
  4. Import my OSC database into Zen Cart
    By Yen_JS in forum General Questions
    Replies: 0
    Last Post: 27 Dec 2010, 08:03 PM
  5. Can I import a 1.3.7 Database into 1.3.8?
    By Big_Woody in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 13 Feb 2010, 12:03 AM

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