Importing my Database when shifted from one host to another

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Importing my Database when shifted from one host to another

Postby y_b » 15. September 2008 05:49

Error
SQL query:

-- -- Dumping data for table `cache_menu` -- INSERT INTO `cache_menu` (`cid`,

`data`, `expire`, `created`, `headers`, `serialized`) VALUES ('router:',

0x613a3537313a7b733a343a226e6f6465223b613a32363a7b733a353a227469746c65223b733a373a22

436f6e74656e74223b733a31333a22706167652063616c6c6261636b223b733a31373a226e6f64655f70

6167655f64656661756c74223b733a31363a2261636365737320617267756d656e7473223b613a313a7b

693a303b733a31343a2261636365737320636f6e74656e74223b7d733a343a2274797065223b693a343b

733a363a226d6f64756c65223b733a343a226e6f6465223b733a31343a226c6f61645f66756e6374696f

6e73223b733a303a22223b733a31363a22746f5f6172675f66756e6374696f6e73223b733a303a22223b

733a363a22776569676874223b693a303b733a31333a225f6e756d6265725f7061727473223b693a313b

733a363a225f7061727473223b613a313a7b693a303b733a343a226e6f6465223b7d733a343a225f6669

74223b693a313b733a383a225f76697369626c65223b623a313b733a343a225f746162223b623a303b73

3a31303a227461625f706172656e74223b733a303a22223b733a383a227461625f726f6f74223b733a34

3a226e[...]

MySQL said:

#2006 - MySQL server has gone away



This was the error i got when i tried to import my database.

I had built a website using Drupal and had to shift it from my laptop to the desktop. I have taken backup of both my website n DB but i encountered this error while importing the db. How do i go about getting my db tables imported. Its urgent!
y_b
 
Posts: 5
Joined: 09. August 2008 11:40

Postby Nobbie » 15. September 2008 11:03

Navigate with an explorer to the data-Folder of your MySQL installation on your laptop (i.e. c:/mysql/data or c:/xampp/var/mysql or similar - you should see at least a subfolder "mysql") and copy all subfolders from the laptop to the desktops MySQL data folder (ignore explorer warnings "already exists...").

After then restart desktop MySQL and you have all MySQL Databases (including drupal) in your desktops MySQL.
Nobbie
 
Posts: 8772
Joined: 09. March 2008 13:04

Laptop not longer with me

Postby y_b » 16. September 2008 05:37

The reason i had to shift my db n site from laptop to desktop is because I had to release my laptop.
I no longer have the laptop n the memory from my laptop has also been erased. But i had copied the whole xamp folder from laptop so lemme see if your soltn works.
Neways thanks for ur help. Will post on implementing ur soltn............
y_b
 
Posts: 5
Joined: 09. August 2008 11:40

THANKSSSSSSSSSSSSSSSS

Postby y_b » 16. September 2008 05:42

I TRIED UR SUGGESTION ................ IT WORKED!!!!!!!!!!!!!!!!!!!!!!!!

THANK U THANK U THANK U !!!!!!!!!!!!!!!!!!!!!!!!! :D
y_b
 
Posts: 5
Joined: 09. August 2008 11:40


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 88 guests