Site lossed have database backup though

5 May 2009, 5:25 AM

#1

braiden1

New Zenner

Join Date:: Mar 2009
Posts:: 13
Plugin Contributions:: 0

Site lossed have database backup though

So i lost all the files to my site BUT i was lucky enough to have a backup of the database and my template

so i have reinstalled zencart, copied the template and have that working

im trying to restore the database through phpmyadmin but i cant seem to get it to work

what steps do i need to do to restore the database?

5 May 2009, 7:46 AM

#2

tophand

Totally Zenned

Join Date:: Jan 2007
Location:: 1.5 miles from Home
Posts:: 674
Plugin Contributions:: 0

Re: Site lossed have database backup though

https://www.zen-cart.com/tutorials/index.php?article=103

5 May 2009, 8:56 AM

#3

braiden1

New Zenner

Join Date:: Mar 2009
Posts:: 13
Plugin Contributions:: 0

Re: Site lossed have database backup though

i tried through phpmyadmin like the above link says, and it doesnt seem to work might be as my database is around 2.5mb....

5 May 2009, 9:05 AM

#4

tony_sar

Totally Zenned

Join Date:: Jul 2006
Location:: Montreal, Canada
Posts:: 2,276
Plugin Contributions:: 0

Re: Site lossed have database backup though

please elaborate on Not working part .. what errors do you get if any ..

dose your original ( back up ) use table prefixes ? what about new database tables ??

5 May 2009, 10:31 AM

#5

braiden1

New Zenner

Join Date:: Mar 2009
Posts:: 13
Plugin Contributions:: 0

Re: Site lossed have database backup though

i will try again tommorrow when i am at work, though the page just comes up blank, get a big list of red errors or it gives some other error ( will post them here when i retry it)

No prefix on the tables.

5 May 2009, 11:30 AM

#6

mprough

Totally Zenned

Join Date:: Nov 2007
Location:: Woodbine, Georgia, United States
Posts:: 4,302
Plugin Contributions:: 39

Re: Site lossed have database backup though

Create a new database..... Then paste your dump incrementally in the SQL tab for larger databases.

Be certain to grab it in parts ending with a ;

~Melanie

PRO-Webs, Inc. since 2003

5 May 2009, 8:59 PM

#7

braiden1

New Zenner

Join Date:: Mar 2009
Posts:: 13
Plugin Contributions:: 0

Re: Site lossed have database backup though

Be certain to grab it in parts ending with a ;

ahhh ok

thats what i will do

6 May 2009, 4:16 AM

#8

braiden1

New Zenner

Join Date:: Mar 2009
Posts:: 13
Plugin Contributions:: 0

Re: Site lossed have database backup though

Yay

found an easy way to do it using navicat.