EricT Posted November 2, 2015 Posted November 2, 2015 Hi, I had to import a big database. I ususally use SQLDumpSplitter. But with this solution, I have to import all files one after one into the new database. When I do that on local, I put the upload limit to 256mo. But on my live server, I don't want to increase this limit (now it is 2mo) Do you know some php script which can do that : - First I upload on serveur the .sql file - I give the db name, login and password to the script and it splits the file and updload by itself all splitted file to the database. Thank you ! (sorry for my bad english)
Ioannis D Posted November 2, 2015 Posted November 2, 2015 I use in the past BigDump PHP script to import big database but I think the best solution is to go with SSH (if you have access) and give: mysql -u [username] -p newdatabase < [database name].sql
ASTRAPI Posted November 3, 2015 Posted November 3, 2015 Just use mysqldump from ssh for import and export :)
Paul.F Posted November 3, 2015 Posted November 3, 2015 http://www.ozerov.de/bigdump/ Is another great tool, have used it and it works well.
EricT Posted November 3, 2015 Author Posted November 3, 2015 Hi, Thank you ! I will try first bigdump php script, because I am not very confortable with ssh.
ASTRAPI Posted November 3, 2015 Posted November 3, 2015 If you don't want to use ssh then try Mysqldumber: http://www.mysqldumper.net/
Starship Posted November 4, 2015 Posted November 4, 2015 Always use ssh if you have ssh access .. it's super easy, just try.
Paul.F Posted November 4, 2015 Posted November 4, 2015 1 hour ago, Afternova said: Always use ssh if you have ssh access .. it's super easy, just try. Not necessary. For people who may not be overly tech savy you may find they will have problems importing a large database using ssh, mysql timeouts. Using a script that is safe gets around this by doing the import in blocks. I would recommend people only use SSH if they are comfortable in doing so, doing the wrong thing in there can kill your site. And ALWAYS make a backup before doing anything that could damage the site, always.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.