dicky96 Posted April 2, 2008 Share Posted April 2, 2008 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 More sharing options...
mwasif Posted April 2, 2008 Share Posted April 2, 2008 Read this to increase file size limit. You can also use MySQL commands to import data e.g. mysql> source file_path.sql referer to MySQL Manual. Link to comment https://forums.phpfreaks.com/topic/99217-importing-sql-databases/#findComment-507715 Share on other sites More sharing options...
gluck Posted April 2, 2008 Share Posted April 2, 2008 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 Link to comment https://forums.phpfreaks.com/topic/99217-importing-sql-databases/#findComment-507825 Share on other sites More sharing options...
eros-sore Posted July 26, 2008 Share Posted July 26, 2008 and what is the right syntax ? i an trying with load data local infile '/Sql38784_1.sql'; and it says error in sql syntax. i am using ySQL Database Version 4.0.18 10q Link to comment https://forums.phpfreaks.com/topic/99217-importing-sql-databases/#findComment-600300 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.