[rAyVax]

Hi there,
(first of all, i'm french and not very skilled in english, i will do as i can do to be understood).

I'd like to import a database on a webserver (wich supports php, mysql, etc...). So i have got the db on my computer, i can use phpmyadmin to import the db on the server and i have linux and windows (but i'm not at ease on unix os, hem!).
The importation of de database fails because i presume that the provider cut off too long mysql queries. To avoid that, i ve found a script called BigDump, I have read and followed the readme and i have an error message when i go on http://.../dump/dump.php (i have uploaded my db at gz format and sql format...)
Here it is:

Code:

Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php on line 70

Warning: Cannot modify header information - headers already sent by (output started at /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php:70) in /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php on line 72

Warning: Cannot modify header information - headers already sent by (output started at /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php:70) in /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php on line 73

Warning: Cannot modify header information - headers already sent by (output started at /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php:70) in /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php on line 74

Warning: Cannot modify header information - headers already sent by (output started at /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php:70) in /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php on line 75

Warning: Cannot modify header information - headers already sent by (output started at /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php:70) in /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php on line 76
BigDump: Staggered MySQL Dump Importer ver. 0.22b

Warning: fopen() [function.fopen]: Unable to access writersofthewind in /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php on line 321

Warning: fopen(writersofthewind) [function.fopen]: failed to open stream: No such file or directory in /mnt/112/sdb/0/b/writersofthewind/dump/bigdump.php on line 321

Can't open writersofthewind for import

You have to upload the writersofthewind to the server

Start from the beginning (DROP the old tables before restarting)

© 2003-2006 Alexey Ozerov - BigDump Home

I will appreciate if you could give me a hand on this problem.
Thanks.
ray

[mab]

The 1st warning message means that the script is attempting to change the execution time limit, but the safe mode setting does not allow this to be changed by a script. You can ignore this warning and the next five warnings (they are caused by the output of the 1st warning message.)

The script is attempting to set the execution time limit to avoid a time out error. This is probably the same error you are getting with phpmyadmin (since it is just a PHP script too.)

If your mysql server allows a remote connection (through it's IP address), you can avoid this script time out problem by using a program like the mysql administrator to load your database. Mysql administrator runs on a PC, connects to your mysql server, and provides similar functionality to phpmyadmin. See this link - http://www.mysql.com/products/tools/administrator/

The rest of the error messages have to do with the script not being able to open your file. I do not see an extension mentioned in the error message. Make sure you give the script a full file name like - myfile.sql Make sure that the path to the file is correct. It is also possible that the script cannot read the file because the file does not have the proper permissions set on it. If you are able to use the mysql administrator program, these problems with the file will go away, because the file will be on your PC instead.

[rAyVax]

Ok... I have found the soft... but i am not able to reach my host. (free.fr)

"Mysql Error Number 2003
Can't connect to Mysql server on XX.XX.XX.XX "




...




Ok , i think it is dead.
I've found that on my provider's website. (why not sooner......... )

Code:

Seuls les scripts php hebergés sur les pages persos ainsi que http://sql.free.fr peuvent permettre de se connecter sur la base de données. Aucune connexion ne peut etre établie depuis l'extérieur sur les bases de données de Free.

It means: You can't access to mysql server by other ways than the phpmyadmin provided by the provider... All outsiding connexion is impossible.
raaaaaaaaaah


Thanks anyway

[rAyVax]

And the last but not least, the provider doesnt allow CHMOD... yipihhh!




My other solution was to submit to 1and1 a 1YearFree submission to a .info
But it is only for Canada and USA... grrrr

[mab]

Since you are limited to local access to the mysql server and from your 1st post you are having problems with phpmyadmin, an option would be to break your .sql file up into smaller parts and load them one at a time using phpmyadmin.

[rAyVax]

I have thought to do that but the bdd is too heavy...