Thread: Mysql databases

Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    202
    Plugin Contributions
    0

    Default Mysql databases

    my store was recently hacked and i started fresh. is there a way to import some of my data from an old database to a new one so i wont ahve to do everything all over again?

  2. #2
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: Mysql databases

    You can export your old database independently of Zen Cart and import it to a new new one using tools such as phpMyAdmin. You could even point your new installation to your old database.

    Two caveats though ...

    If you were hacked you may have been using an old version of Zen Cart, and so will need to upgrade it. There are instructions for that in the FAQ.

    If your site was hacked, data may have been inserted into your database, and so its contents should be inspected before you try re-using it. There's a little more on this in this section, which is worth reading, even if you're starting again to ensure that you don't get hacked again.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  3. #3
    Join Date
    Aug 2010
    Posts
    202
    Plugin Contributions
    0

    Default Re: Mysql databases

    is there a way to open up the file and remove information from it? like my product info and descriptions?

  4. #4
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: Mysql databases

    The export contains a series of SQL install statements, and unless you zip it, it's a plain text file that you can read and edit in any test editor.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

 

 

Similar Threads

  1. Replies: 7
    Last Post: 19 Sep 2010, 11:48 AM
  2. Access multiple mySQL databases at once (???)
    By jeffmic in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 6 Dec 2006, 02:12 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