|
|
|
|
Joined: Mar 2003
Posts: 215
Junior Member
|
|
Junior Member
Joined: Mar 2003
Posts: 215 |
I'm having problems importing my DB onto XP.
I've dumped my forum using mysqldump into a file (forumnov2203).
We have no problems importing a backup like this on our linux server.
To create the backup I'm performing:
mysqldump --opt -u USERNAME -p DBNAME > BACKUPFILE.sql
On XP I carry out this:
C:\mysql\bin>mysql -u root forum < forumnov2203
But after a minute or 2 I end up getting this:
ERROR 2013 at line 760: Lost connection to MySQL server during query
I've tried playing with timeouts, and max packet sizes. I can't get past these errors. I can import the same dump on linux just fine though.
The dumpfile is 190mb.
Can anyone help?
|
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
|
Member
Joined: Apr 2001
Posts: 3,266 |
what is this for you test site on a closed lan?
|
|
|
|
|
Joined: Mar 2003
Posts: 215
Junior Member
|
|
Junior Member
Joined: Mar 2003
Posts: 215 |
|
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
|
Member
Joined: Apr 2001
Posts: 3,266 |
HMM I can't see anything your doing wrong. However there are about a zillion things that can do wrong with Gatesware.
Have you tried restoring the dump via PhpMyAdmin?
|
|
|
|
|
Joined: Dec 2000
Posts: 1,471
Addict
|
|
Addict
Joined: Dec 2000
Posts: 1,471 |
Does your mysql error log provide any message why the mysql server is going away?
|
|
|
|
|
Joined: Mar 2003
Posts: 215
Junior Member
|
|
Junior Member
Joined: Mar 2003
Posts: 215 |
phpMySql (which I've never used before actually) gives me this after several minutes:
Notice: Undefined variable: db in C:\Program Files\Apache Group\Apache2\htdocs\phpMyAdmin\read_dump.php on line 191
Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Apache Group\Apache2\htdocs\phpMyAdmin\read_dump.php:191) in C:\Program Files\Apache Group\Apache2\htdocs\phpMyAdmin\main.php on line 16
etc.
|
|
|
|
|
Joined: Oct 2000
Posts: 2,223
Veteran
|
|
Veteran
Joined: Oct 2000
Posts: 2,223 |
Stick this in your my.cnf file
set-variable = max_allowed_packet=16M
if you're on a 4.x the syntax might be a little different. You might need to change the packet size, perhaps increase it.
My guess is your forum is rather large.
Picture perfect penmanship here.
|
|
|
|
|
Joined: Mar 2003
Posts: 215
Junior Member
|
|
Junior Member
Joined: Mar 2003
Posts: 215 |
I've tried various sizes up past the size of the file even. When I set it too low though it does give a packet size error instead.
I'm going to try a table by table export soon instead, and look into setting up the logs properly next.
|
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
|
Member
Joined: Apr 2001
Posts: 3,266 |
table by table will usually work though you may have some problems with w3t_Posts as that is the one that gets big
|
|
|
|
|
Joined: Mar 2003
Posts: 215
Junior Member
|
|
Junior Member
Joined: Mar 2003
Posts: 215 |
It was w3t_Posts that it couldn't get imported. I figured I would tried some more things before replying to this post. Then the idea of using the same version of mysql install that's on the linux server itself might have a difference. So I got 3.23.58 instead of the latest version and it magically works now 
|
|
|
|
|
Joined: Jul 2001
Posts: 1,157 Likes: 82
coffee and code
|
|
coffee and code
Joined: Jul 2001
Posts: 1,157 Likes: 82 |
Last edited by id242; 07/14/2004 4:14 PM.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 21,079
Joined: March 2000
|
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
