2

We have a Magento site.

We have a large database of 1000MB for that site.

When we try to import database through phpmyadmin, it's not uploading the full database. Lot of tables are missing after uploading.

Qe are getting this error :

Script timeout passed, if you want to finish import, please resubmit same file and import will resume

We have a GoDaddy cpanel and phpmyadmin.

Is there any way to upload a large database completely?

I am planning to change php.ini settings as mentioned in this question:

How to solve time out in phpmyadmin?

But I could not able to find php.ini file.

Have I need to edit the default Magento phi.ini.sample?

Community
  • 1
  • 1
  • Tell us something more about your host. Its a shared hosting, its a VPS or a dedicated server? Do you have root access? – Kyto Jul 23 '15 at 10:01
  • godaddy its a shared hosting, we have a ssh access. –  Jul 23 '15 at 10:03
  • Why don't you compress the file - .sql files can be nicely compressed in most of the cases. – Shomz Jul 23 '15 at 10:06
  • we tried that, now its 98mb, still not uploading, so we planning to chnage settings size in php.ini file –  Jul 23 '15 at 10:08
  • 1
    For databases that large, I think it is best to use mysqldump to dump SQL file and mysql command-line interface to import the SQL. – YudhiWidyatama Jul 23 '15 at 10:13
  • okay, we will try commands by putty software. –  Jul 23 '15 at 10:15
  • is there any way in phpmyadmin or through ssh, we can change the old domain name to new domain name in all places in database file –  Jul 23 '15 at 11:05

2 Answers2

0

use sqlsplitter, It will created small chunk of you large sql file and then upload all these small files

HKumar
  • 1,535
  • 3
  • 13
  • 28
  • Yes, you have to download it. It is very light weigh but effective. check this link. http://www.rusiczki.net/2007/01/24/sql-dump-file-splitter/ – HKumar Jul 23 '15 at 10:07
  • is there any way in phpmyadmin or through ssh, we can change the old domain name to new domain name in all places in database file –  Jul 23 '15 at 11:05
  • yes, there are plenty of script that search in the database and change the domain name in database. – HKumar Jul 23 '15 at 11:12
  • Check this url https://interconnectit.com/products/search-and-replace-for-wordpress-databases/ It will definitely help you. – HKumar Jul 23 '15 at 11:16
  • thanks a lot, we will try this. is there any ssh commands that can replace the old doamin name to new domain name? –  Jul 23 '15 at 11:26
  • I don't have any idea about that command, I generally use this script for the changes. – HKumar Jul 23 '15 at 11:35
  • How do you even upload multiple files within phpMyAdmin ? –  Apr 11 '19 at 13:47
-1

Try like this in your Godaddy SSH,

  1. Log on to your server.
  2. At the command line, type su -. This gives you root access.
  3. At the command line, type mysql -uroot -p
  4. Enter your MySQL root password.
  5. Select yourdatabase name for insert data by writing this command, USE YOURDATABASENAME
  6. Then load source sql file as SOURCE D:\profile20\database.sql
  7. Press enter for insert data.

This video link may help you.

alagu
  • 779
  • 1
  • 5
  • 19
  • "godaddy its a shared hosting, we have a ssh access" asked before – Kyto Jul 23 '15 at 10:19
  • is there any way in phpmyadmin or through ssh, we can change the old domain name to new domain name in all places in database file –  Jul 23 '15 at 11:05
  • you mean you are looking something like this ?https://www.youtube.com/watch?v=NkEewzaIzbU – alagu Jul 23 '15 at 11:14
  • i used this : mysql -uUSERNAME -p DATABASE < path/to/dump.sql its works fine. –  Jul 23 '15 at 14:03