So … sometimes you on shared hosting and you need to import a large database. Problem phpmyadmin only supports a max of > 50MB. So the first option is to check the php.ini or the cursed .htaccess file – however many times shared providers override these or won’t allow an apache restart immediately.
2- Open bigdump.php in a text editor, adjust the database configuration and dump file encoding.
3- Drop the old tables on the target database if your dump doesn’t contain “DROP TABLE” (use phpMyAdmin).
4- Create the working directory (e.g. dump) on your web server
5- Upload bigdump.php and the dump files (*.sql or *.gz) via FTP to the working directory (take care of TEXT mode upload for bigdump.php and dump.sql butBINARY mode for dump.gz if uploading from MS Windows).
6- Run the bigdump.php from your web browser via URL likehttp://www.yourdomain.com/dump/bigdump.php.
7- Now you can select the file to be imported from the listing of your working directory. Click “Start import” to start.
8- BigDump will start every next import session automatically if JavaScript is enabled in your browser.
9- Relax and wait for the script to finish. Do NOT close the browser window!
— IMPORTANT: Remove bigdump.php and your dump files from your web server.
A little about me - Experienced senior Business/System Analyst with Project Management Experience and a flare for design. I've also got a couple years ESL instruction experience.
MYMOTTO
Dream, Dedication, Determination, Direction and Destination.
COMMENTS
0 Responses to BigDump SQL Import