Jump to content

Importing sql databases


dicky96

Recommended Posts

Hi

I'm trying to import a mysql database.  The database is one I have exported from my host webserver, using phpmyadmin which is installed there.  The database downloaded to my PC as a .sql file

 

I want to import it to my local server so I can play around with some home brewed php extensions/plugins  (its a vbulletin based site) and not risk breaking the live site.

 

When I run phpmyadmin locally (which I am not really familiar with) I am clicking on IMPORT, browsing to the file, and then clicking on GO

 

and it tells me import has been successfully finished, 0 queries executed.

 

The file is quite big - about 9.7Mb - I noticed in phpmyadmin it says max 2Mb so I edited php.ini to say

 

upload_max_filesize=16M

 

and in phpmyadmin it now says max is 8Mb ???

 

Is this just a file size problem or am I just doing something stupid wrong?

 

best regards

dicky

 

 

Link to comment
https://forums.phpfreaks.com/topic/99217-importing-sql-databases/
Share on other sites

Hi

I'm trying to import a mysql database.  The database is one I have exported from my host webserver, using phpmyadmin which is installed there.  The database downloaded to my PC as a .sql file

 

I want to import it to my local server so I can play around with some home brewed php extensions/plugins  (its a vbulletin based site) and not risk breaking the live site.

 

When I run phpmyadmin locally (which I am not really familiar with) I am clicking on IMPORT, browsing to the file, and then clicking on GO

 

and it tells me import has been successfully finished, 0 queries executed.

 

The file is quite big - about 9.7Mb - I noticed in phpmyadmin it says max 2Mb so I edited php.ini to say

 

upload_max_filesize=16M

 

and in phpmyadmin it now says max is 8Mb ???

 

Is this just a file size problem or am I just doing something stupid wrong?

 

best regards

dicky

 

 

 

use command line mysql options

  • 3 months later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.