Current Page: 1 of 1
Results 1 - 6 of 6
10 years ago
IrvC
I finally found an editor that could open a file of this size and see that it was the export that died, not the import. The error message I reported earlier is at the end of the export file and is not being generated by the import after all. thanks for your help on this. I assume that my host can resolve the export timeout problem and I will be all set.
Forum: WampServer English
10 years ago
IrvC
yes the file was created by using the Export feature of phpMyAdmin on the host for our live site. Looks like I need to scrub the data and re-export??
Forum: WampServer English
10 years ago
IrvC
First I issued the command: use <database.name> then the command: source <path\filename.sql; so I don't know how there could be an error in the script, but it did respond after a while: ERROR 1064 (42000): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '<br /> <b>Fatal erro
Forum: WampServer English
10 years ago
IrvC
Ok I created the database in phpMyAdmin and started the import but it timed out before completing. Then I went to the MySQL console and used the source command, which got much further but it timed out after 300 seconds before completing. Can I change the 300 second maximum execution time?
Forum: WampServer English
10 years ago
IrvC
thank you for your reply. I have a couple related questions: 1) when I first launched phpMyadmin in WAMP I was prompted for a username and password. I entered the username for my live site database, which I guess was the wrong thing to do. I can launch phpMyadmin using this username and leaving the password blank. Should I have created a new username and password? Where would I do that?
Forum: WampServer English
10 years ago
IrvC
I am trying to import the database that I exported from our live site to WAMP using phpMyAdmin. I browse for the .sql file that the export created and click GO. I tried leaving SQL compatibility mode as NONE, and also selected MYSQL40 and MYSQL323 for compatbility mode. I am getting error #1046 - No Database Selected. Any clues? Irv Windows 7 WAMP ver. 2.4 (just downloaded this w
Forum: WampServer English
Current Page: 1 of 1