WampServer

I have a database backup that is 252mb and is in .sql format. I need to upload this to my server. I have a 2mb restriction on my phpmyadmin. I have edited my php.ini file to make it 300mb but it then limits it to 8mb. I have searched through various php files in the C:\Wamp folder and changed any occurrences that seemed like they would be affecting the upload/import limit. I changed something and then my phpmyadmin told me that this server doesn't allow imports so uninstalled and reinstalled WAMP5.

Could someone please help me, this is very important to me?



Post Edited (07-01-07 18:36)

open php.ini, and search for 8m there is a setting thats 8mb by default to limit it or something

I have done that already.

When you have edited php.ini and made all the changes, did you restart Apache??

When you change php.ini you need to restart Apache!!!!!

to upload your sql file, put it in the mysql/bin directory.
Open a windows command line. Go the the mysql/bin directory.
Type :

mysql -uroot -pxxx < file.sql

Where xxx is your root password and file.sql is your sql file.



Romain

Are you sure you editted the right file?

To be sure, edit your folder settings to show file extensions.