database is too big to import

[JpK]

Hiiiiiya

I'm trying to import an old forum database into my vps phpmyadmin but it says its too big...

How do I increase the upload size? I Googled it up and it says to edit php.ini config file...

I found php.ini-development and php.ini-production which one? and am I in the correct location?

 

[Qodex]

When it does that, I refresh and try again. It works for me.

 

[JpK]

When it does that, I refresh and try again. It works for me.

@_@ Refreash what?

 

[Qodex]

PHPMyAdmin

 

[Thom]

Go to your phpMyAdmin folder and open "config.inc.php".

Add this line somewhere:

$cfg['UploadDir'] = 'upload';

Now make a folder in the phpmyAdmin folder called "upload" and put the database in this folder.
You should be able to select the sql file and do it like this.

 

[Kaz]

And if the above still doesnt work, break the database down and upload it in 2 parts. Its common sense imo

 

[Gibbo]

Hello, I recommend using navicat, it will allow you to upload big files.

 

[Heaplink]

The reason why you really can't do it it because both php and mysql have a upload limit. You have to change both configuration files (since mysql is made in PHP, it uses also PHP's max upload size).

Possible solution:

1. Locate your PHP configuration file php.ini (if you're using IIS, you can find it in the PHP extension menu thing)
2. Find and change upload_max_filesize to about the size of your SQL file (you can just type 1024M or more)

If you get same error try to do the same from step one but just change the post_max_size to something higher too in the php.ini
Remember to restart your IIS or Apache depending on what you use. Try now to upload your SQL file.

 

[Ayumi]

Go to your phpMyAdmin folder and open "config.inc.php".

Add this line somewhere:

$cfg['UploadDir'] = 'upload';

Now make a folder in the phpmyAdmin folder called "upload" and put the database in this folder.
You should be able to select the sql file and do it like this.

This works for me fine.

 

[Kaz]

Thread closed, plenty of suggestions given by Devbesters.
All/Most will work