PDA

View Full Version : Re installed DB


Pirate123
02-09-2010, 01:05 AM
I did a fresh instal of my DB, backed up my old DB, and now i want to load the old DB back into the new one. I tried sourcing it, but i get no progress bar, it just goes to the next line with -> and waits for something to be typed. is there a progress bar or something that tells you how close it is to being done? or am i doing something wrong?

jkennedy
02-09-2010, 09:13 AM
your misspelling or mistyping something

pfyon
02-09-2010, 09:47 AM
That happens (at least through command line) when you miss a semicolon at the end, as it expects one before it executes the command.

Pirate123
02-09-2010, 03:47 PM
hmm, ok now i got it to work, but i get a MYSQL server has gone away error when uploading the db

nilbog
02-09-2010, 07:58 PM
Try increasing the size of your max_allowed_packets in your mysql configuration file.

Here's a quick google search tutorial link.

http://www.tutorialized.com/view/tutorial/MySQL-max_allowed_packet-MySQL-gone-away-problem/41390

pfyon
02-09-2010, 08:33 PM
Did you re-grant privileges to the new db? Also, flush privileges;