MySQL troubles

[IR15H]

Originally Posted by jchamber2010

Do not restore the Custom Avatars table until last, as it stores large amounts of data, and can make your queries stop working, also use a script called bigdump http://www.ozerov.de/bigdump.php to import it to prevent memory overloads when trying to import large databases, as phpMyAdmin is limited by how much memory that PHP can use. This imports only a little at time and then moves on, making memory overloads rarely happen.

Anyway I hope this helps

Thanks for your reply. The sql file I have has all the tables in one, so I have no control over which tables it chooses to restore first (at least, I don't think). I attempted to use "Big Dump" but ran into pretty much the same problem;

Error at the line 25369: ...LOADS OF NUMBERS...equilibrium-ani2a.gif...LOADS OF NUMBERS...

Query: INSERT INTO `vb_customavatar` (`userid`,`filedata`,`dateline`,`filename`,`visibl e`,`filesize`,`width`,`height`,`filedata_thumb`,`w idth_thumb`,`height_thumb`) VALUES

...LOADS OF NUMBERS...equilibrium-ani2a.gif...LOADS OF NUMBERS...

MySQL: Got a packet bigger than 'max_allowed_packet' bytes
Stopped on error

I've set the max packet size to 10000M, (which I confirmed took effect by looking in phpMyAdmin > Variables > max allowed packet 1,048,576) so don't really see how the above error can be true as the entire sql file is less than 100MB.

-----------------------------

Originally Posted by DragonBlade

Ouch, no way that you can use a Linux server, eh? If so, it'd be a lot easier to help ya. XD That's just because I'm more familiar with the commands.

Anyways, there's a few methods available to you. BigDump as described above by jchamber2010 is one I've surprisingly not heard of until now, but seems it's been around since 2003. Still, with a "0.29b" version, I think I'd stick with something a bit more well known. xP

MySQL Dumper ( http://www.mysqldumper.de/en/ ) is what I use when I don't have shell access to servers, but I do have FTP access. (When I have shell access, I just execute the command-line statements to restore a database, but I honestly have no idea how to do that in Windows. I'm sure there's got to be a way, though, and that would probably be your BEST option.)

In theory I could install Linux, but that'd probably take me another few days . I wouldn't have the first idea how to use it either, if I did manage to install it. I also suspect that I'll just run into the same sort of problems on there also.

I tried the program you suggested, thanks. Unfortunately that gave an error of;

Error in Query:

MySQL says:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUES (93,'count_depth','1',1055,'yesno','',1,-1)' at line 1

I have no idea what that means, or where to check to try and fix it.

-----------------------------

Originally Posted by Paul M

That error has no bearing on how useful those backups are, and you can import them direct into mysql using ssh access.

As to the error, what is your wait_timeout set to in my.ini ?

Sorry, I didn't mean to sound like I was implying the backup weren't useful. What I was trying to say is that MySQL Admin won't run them - and that's the only way I know how to restore SQL files at present. Is SSH Linux only? Is there a similar method I could run through Command Prompt for Windows?

Time out is set to 180 seconds, the error pops up after less than 10. Due to that, I assume this isn't the issue (or else it's be at least 180 seconds before the error)?

-----------------------------

I tried downloading some sql editor thing, Apex and seeing if I could just delete the damn table from the backup. Unfortunately, I get a "System.OutOfMemoryException: Out of memory." error when trying to opn my SQL file in it. I can manage to open smaller SQL files, so I'm guessing it just crashes because it's too big a file for it to open .