PDA

View Full Version : Minisqlerror.

SputniQ
3-7-06, 03:38 AM
clust10-www04.powweb.com
11:35PM up 109 days, 12:13, 0 users, load averages: 0.54, 0.80, 0.95
u='hlforum.net', p='********', h='mysql19.powweb.com', d='hlforum_net', f='hlforum.sql', t='+', r='1' m='1', res=''
Restoring with 'mysql' (backupfile='hlforum.sql') ...
minisqldump.cgi: cannot open : no such file
Done.
--------------
Show Table Status
--------------

Empty set (0.01 sec)

Bye
11:35PM up 109 days, 12:13, 0 users, load averages: 0.54, 0.80, 0.95
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
hlforumorg 77971 0.0 0.0 388 232 ?? R 11:35PM 0:00.00 ps uxww
hlforumorg 77963 0.0 0.0 696 364 ?? S 11:35PM 0:00.01 /bin/sh minisqldump.cgi

I get this error message when I try to use the minisqldump, I dont really understand what it says, but something about it not founding my .sql file? Its laying in the same folder.
extras
3-7-06, 08:18 AM
Thank you for reporting.
There was a typo in the restore function.

Can you update MiniSqlDump and try again?
SputniQ
3-7-06, 08:23 AM
hm. nope, didnt do it, The .sql file shall be in the same folder as the minisqldump? I got it there but it says it cant find the file :/
extras
3-7-06, 08:32 AM
Can you post the message (like the first post), again?
What's the version you see?
SputniQ
3-7-06, 08:32 AM
clust10-www01.powweb.com
4:23AM up 6 days, 3:51, 0 users, load averages: 1.18, 1.03, 1.00
u='hlforum.net', p='********', h='hlforum_net', d='mysql19.powweb.com', f='hlforum.sql', t='+', r='1' m='1', res=''
Restoring with 'mysql' (backupfile='hlforum.sql') ...
ERROR 2005 (HY000): Unknown MySQL server host 'hlforum_net' (1)
Done.
ERROR 2005 (HY000): Unknown MySQL server host 'hlforum_net' (1)
4:23AM up 6 days, 3:51, 0 users, load averages: 1.18, 1.03, 1.00
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
hlforumorg 78358 0.0 0.0 388 232 ?? R 4:23AM 0:00.00 ps uxww
hlforumorg 78350 0.0 0.0 696 348 ?? S 4:23AM 0:00.02 /bin/sh minisqldump.cgi
extras
3-7-06, 08:40 AM
Okey, you put host and DB name in the wrong place.
Hsot should be mysql19.powweb.com
and DB should be hlforum_net.
SputniQ
3-7-06, 08:45 AM
oh, sorry, damn I feel like a n00b, btw, got this error message instead.

clust10-www03.powweb.com
4:44AM up 119 days, 7:29, 0 users, load averages: 0.76, 0.97, 1.07
u='hlforum.net', p='********', h='mysql19.powweb.com', d='hlforum_net', f='hlforum.sql', t='+', r='1' m='1', res=''
Restoring with 'mysql' (backupfile='hlforum.sql') ...
mysql: Error reading file 'UNOPENED' (Errcode: 21)
Done.
--------------
Show Table Status
--------------

Empty set (0.00 sec)

Bye
4:44AM up 119 days, 7:29, 0 users, load averages: 0.76, 0.97, 1.07
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
hlforumorg 89192 0.0 0.0 388 236 ?? R 4:44AM 0:00.00 ps uxww
hlforumorg 89181 0.0 0.0 696 356 ?? S 4:44AM 0:00.02 /bin/sh minisqldump.cgi
extras
3-7-06, 09:03 AM
I've never seen this.... mysql: Error reading file 'UNOPENED' (Errcode: 21)
I searched a bit but found no hit on the error, strage ...

To make sure, I just tested backing up and restoring php_bb database, and it went without problem.
So, I'm assuming it's not the error of MiniSqlDump, but thzt of file system or mysql.
extras
3-7-06, 09:07 AM
Take a look at the .sql file.
Can you see anything abnormal?
Isn't it compressed?
SputniQ
3-7-06, 10:39 AM
clust10-www05.powweb.com
6:35AM up 117 days, 11:27, 1 user, load averages: 2.40, 2.40, 2.06
u='hlforum.net', p='********', h='mysql19.powweb.com', d='hlforum_net', f='hlforum1.sql', t='+', r='1' m='1', res=''
Restoring with 'mysql' (backupfile='hlforum1.sql') ...
ERROR 1226 (42000) at line 72667: User 'hlforum.net' has exceeded the 'max_questions' resource (current value: 72000)
Done.
ERROR 1226 (42000) at line 1: User 'hlforum.net' has exceeded the 'max_questions' resource (current value: 72000)
--------------
Show Table Status
--------------

Bye
6:36AM up 117 days, 11:28, 1 user, load averages: 1.77, 2.20, 2.01
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
hlforumorg 56077 0.0 0.0 388 232 ?? R 6:36AM 0:00.00 ps uxww
hlforumorg 55753 0.0 0.0 696 388 ?? S 6:35AM 0:00.01 /bin/sh minisqldump.cgi

THere was something wrong with the file, so I took another one, and THEN I got this error message :/
mitchind
3-7-06, 10:47 AM
You may have to split file - or create a couple of large multiple INSERT statements - instead of the individual ones in the file now.

If you split the file, you can use up to 3 different users - or is it 5 now - I can't remember. Create a couple of new users in Member Ops and use utility again. You'll have to wait another hour to use the same user again once that user has exceeded limit.
SputniQ
3-7-06, 10:48 AM
lol, doh, thanks for both your help :P
extras
3-7-06, 10:50 AM
That one sounds more like you tried old format sql dump with lots of statement.
You may have exceeded max query limit for the hour with it.
(That's why I created default Quick method which uses LOAD DATA LOCAL INFILE.)

You can create another user, and try with smaller DB.
(You can take just first 10-20 queries of .sql file, for testing).
extras
3-7-06, 10:58 AM
Oh, there is a utility that takes .sql with single Insert statement, and converts it to a data file,
and then import using LOAD DATA LOCAL INFILE.
http://check-these.info/tools/restore_cgi.txt

I made it last year and I forgot about it. When you are stuck with old .sql, it's handy.
(It can fail with some data format, though ...)
mitchind
3-7-06, 11:58 AM
Oh, there is a utility that takes .sql with single Insert statement, and converts it to a data file,
and then import using LOAD DATA LOCAL INFILE.
http://check-these.info/tools/restore_cgi.txt

I made it last year and I forgot about it. When you are stuck with old .sql, it's handy.
(It can fail with some data format, though ...)
Now that's a useful tool - is that listed on your website page as well? I see this a lot when dealing with forum backups and even dumps from MS SQL Server if the dump isn't configured properly.
extras
3-7-06, 12:17 PM
Yup it's in the tools section, just like other tools.
http://check-these.info/tools/

Info about several different methods.
http://forum.powweb.com/showthread.php?t=57349
mitchind
3-7-06, 12:22 PM
Great - I added the link to the MiniSQL sticky thread at the top of the forum.
SputniQ
3-8-06, 03:46 AM
ehm, sorry to ask, but what do the new script do? It gave me a new folder with a new .sql file, what Im I doing with it? O.o


one .dat file and a dump.sql.r.sql? O_O
extras
3-8-06, 10:21 AM
What it does:

Oh, there is a utility that takes .sql with single Insert statement, and converts it to a data file,
and then import using LOAD DATA LOCAL INFILE.
http://check-these.info/tools/restore_cgi.txt



Info about several different methods.
http://forum.powweb.com/showthread.php?t=57349


What you are doing with it: The script may help to import .sql with otherwise too may INSERT statements.

New .sql and .dat file is left there for you to examin, but the data should be already loaded to DB.
Chek with MiniSQLAdmin or PHPMySQLAdmin.
As I saif, that script may fail with .sql of certain format.

If you post the .sql file and several lines of .dat file, as well as the output from the script,
probably I can tell if the data conversion went well.
But checking the MySQL DB is the best way to confirm the operation.