Hi, I'm tryimng to import database from another host. The documentation suggests two ways. 1) Import through phpAdmin and 2) import through shell. I placed the dump of the database in the home directory. I then created an empty database with same name and persmissions as on my old host as per documentation. php Admin did not give me an option to import from webfaction but did give option to import from machine. But when I tried to import from my pc, it gave me an error that the database already existed. I contacted support and they said preferred method is shell. So I downloaded putty for windows and logged on with putty. So far so good. They told me to try following commands: mysql -u username -p -D dbasename< /home/myaccount/dump.sql However, when I entered this I've got the error that the database already exists. So I deleted the empty database and then got an error Access denied. With the empty database deleted there does not seem to be a way to access phpmyadmin. This is way harder than the incomplete documentation pretends. Any suggestions? BTW, I also notice that I have to keep signing into the webfaction website almost every time I go to a new page. It doesn't seem to remember that you've logged in even when you check remember me. What is up with that? asked 18 Jun '13, 18:27 user223344 |
What is probably happening is your MySQL dump file contains a Create Database statement. You'll need to ensure that on your other host you export just the schema / data rather than containing commands to create the database. As far as the signup into the control panel goes, you should definitely stay signed in from page to page. Please ensure that your browser has cookies enabled, which should fix that. answered 19 Jun '13, 00:19 waynek |