How do i upload 400 mb sql file? :(

Hey all.I got an ultra big sql file which i need to upload.Would it be possible to upload?Suggest any good hosting(free hosting better).Or any other way? Please.

 

Try these guys. They have great prices and they tech guys will install the SQL for you.

 

Yeah i have a similar question. Not about hosting (i get enough space), but is it possible to upload such a huge database in fragments? if so, how to get it to work?

 

You can upload it and then install it from the command line. The MySQL web interface will not import a file that large.

 

would you mind to explain?

 

I think,you can do that by exporting it to tar.gz,so that it will get compressed and you can have a bit small file..

 

Depends on 1) can you compress [and then more importantly] uncompress the file once uploaded? 2) transfer speed while uploading

Don't know if you'll get SQL for free though - good luck.

 

1. Put the sql file on your server
2. Get bigdump.php
3. Configure big dump w/the correct sql connection info
4. Put bigdump.php on your server
5. Browse to http:/yoursite.com/bigdump.php
6. Select the sql file
7. Success

If you have any issues please contact me and I can assist you for a small fee.

 

Hmm when i run big dump, it give me this error :?

Error at the line 4232: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

Query: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

MySQL: Variable 'sql_mode' can't be set to the value of 'NULL'

 

yeah big dump is what i use also...

it means your old_sql_mode;s value is null

 

i don't understand can u help me ?

tell me full procedure ? pls

 

splt the file to like 100mb parts depending on your connection

end 1 part at ";" and after that there should be the statment "CREATE" or along those lines

 

Do you have SSH access?

SSH into your system then do:

mysqldump -uuser -p db_name > backup-file.sql

Code (markup):

You can then FTP this file over to your new server.

SSH into the other server and run"

mysql -uusername -p db_name < backup-file.sql

Code (markup):

 

nice tutorial

 

Why thank you sir.

I actually have written way more advanced for backup purposes.

Using --hex-blob and then tgz, scp over to remote location as backup etc.


But as for the basics. It does not get more simple then what I posted =)

 

i have no ssh access ? pls help me out how can i do with big dumb

it give me this error :?

Error at the line 4232: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

Query: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

MySQL: Variable 'sql_mode' can't be set to the value of 'NULL'
__________________

 

i always use mysqldumper works great

 

@OLD_SQL_MODE is giving you a NULL value.

Just write a simple PHP script to call the system commands that I gave you.

Example:

<?
$jon = system("mysqldump -uuser -p db_name > backup-file.sql");
?>

Code (markup):

 

Thanks, buddy!
You have helped me solve one of my real old problems with that tip about bigdump

 

hey man, I also want to say thanks. This little tutorial helped me a lot. Thanks!!!