Hi all,

I have a file with 9 MB (vbulletin.sql). After upload the file, using phpMyAdmin, the error show: No Query!

How I restore this file 9 MB (backup)?

My server has: 1 processor (Celeron 1.7 with 512MB ram)
My my.cnf:

[mysqld]
skip-innodb
skip-locking
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
interactive_timeout=100
wait_timeout=100
connect_timeout=10
join_buffer=1M
max_allowed_packet=16M
record_buffer=1M
max_connect_errors=10
thread_cache_size=50
key_buffer=40M
table_cache=384
sort_buffer_size=768K
read_buffer_size=512K
read_rnd_buffer_size=512K
thread_concurrency=2

Thanks all by any help...

Open the .sql file and take a look for anything out of the ordinary Might be a problem in the file itself

use ssh to import it ...

mysql -u username -p database < /path to /vbulletin.sql

Originally posted by MarcD
Open the .sql file and take a look for anything out of the ordinary Might be a problem in the file itself

Hi MarcD,

It does not have no problem in the archive. Any idea? :confused:

Originally posted by inteltechs
use ssh to import it ...

mysql -u username -p database < /path to /vbulletin.sql

Hi inteltechs,

I use: mysql -u user -p pass -D database </path/vbulletin11.sql>

But file not import... :bawling:

You've messed up the <>s, let me explain

First try 'mysql -u user -p pass'
If this connects, type in 'use databasename' where databasename is the name of your database
If this works, type in '/. path/to/file' where path/to/file is the path to your SQL file.

Now i'm not entirely sure if it's /. or what, but there is a help file to help you out, hope this helps!

The error is that you can't upload 9mb file through HTTP before your session timed out. (normally 30 secs) so the server doesn't receive the file.

You need to put the sql file on the server (FTP, scp..) then run that command from the shell to reload the file.

Again:
If you FTP the file.sql to your home directory on the server, for example it's at /home/yourname/file.sql and you're reloading yourname_mydatabase database
then your query may look like this:
$ mysql -u yourname -p yourname_mydatabase < /home/yourname/file.sql

ML

Hi nmluan and Winkie and inteltechs and all others! :)

You saved my weekend!! Thanks very much... :D