trying to move my phpbb database using phpmyadmin
Moderator: General Moderators
trying to move my phpbb database using phpmyadmin
I'm having some problems here.
My board is phpbb 2.04 and I would like to upgrade to 2.08, and I'm testing it on a "test server online" I've got a few mods install that I don't really care about losing.
I backed up my database using PHPmyAdmin because I read that it does a better job than the "back up database" phpbb uses in the admin panel.
I've gone to my test server, and clicked on SQL>>> Browse to the gziped file on my computer>>>Go
Nothing it's happening, I can't see my phpbb tables on the new server. I get this message
"No SQL query!"
Below is the extension looks of the file I'm trying to upload, what am i doing wrong pls anyone?
phpbb__db__backup3[1].sql.gz
My board is phpbb 2.04 and I would like to upgrade to 2.08, and I'm testing it on a "test server online" I've got a few mods install that I don't really care about losing.
I backed up my database using PHPmyAdmin because I read that it does a better job than the "back up database" phpbb uses in the admin panel.
I've gone to my test server, and clicked on SQL>>> Browse to the gziped file on my computer>>>Go
Nothing it's happening, I can't see my phpbb tables on the new server. I get this message
"No SQL query!"
Below is the extension looks of the file I'm trying to upload, what am i doing wrong pls anyone?
phpbb__db__backup3[1].sql.gz
I hope I don't <span style='color:blue' title='I'm naughty, are you naughty?'>smurf</span> you off Mark or anyone, pls just be patient. I've got everything I need now I believe.
moving database from Website A to B.
1. backup/download to my computer~~~I did.
so would the next step be to FTP the sql file to Website B it's quite big, 57.MB...or did you mean for me to use WinSCP to get it onto my server?
After, run the command prompt on my server for website B to restore using the code mysql -u username -p thedbname < phpbb__db__backup3[1].sql ..I know I'll need to add my username dbname etc....
Is this the right pls? thank you for your patience.
moving database from Website A to B.
1. backup/download to my computer~~~I did.
so would the next step be to FTP the sql file to Website B it's quite big, 57.MB...or did you mean for me to use WinSCP to get it onto my server?
After, run the command prompt on my server for website B to restore using the code mysql -u username -p thedbname < phpbb__db__backup3[1].sql ..I know I'll need to add my username dbname etc....
Is this the right pls? thank you for your patience.
Not at allI hope I don't <span style='color:blue' title='I'm naughty, are you naughty?'>smurf</span> you off Mark or anyone
Yep, that's the theory. You should be able to use either ftp or scp to get the .sql file onto the server. ftp might be better if you don't need the extra security scp offers, plus, ftp is faster
Thanks, I did that, the message I'm getting is "no such file or directory"
I did this in my url, http://www.url.com/phpbb.sql and i can see it there but when I do
mysql -u username -p thedbname < phpbb.sql
I get "there's no such file or directory".
I also tried
mysql -u username -p thedbname < /home/users/myusername/phpbb.sql
because that's the file path and it still returned the same error, anymore idea pls?
I did this in my url, http://www.url.com/phpbb.sql and i can see it there but when I do
mysql -u username -p thedbname < phpbb.sql
I get "there's no such file or directory".
I also tried
mysql -u username -p thedbname < /home/users/myusername/phpbb.sql
because that's the file path and it still returned the same error, anymore idea pls?
No solution given, but another idea.
You might want to test the win32 software http://www.mysqlfront.de/
It supports site -> site copying abit better (imho) that phpmyadmin does. I'm using this quite alot myself when copying/backing up large masses of data between software...
You might want to test the win32 software http://www.mysqlfront.de/
It supports site -> site copying abit better (imho) that phpmyadmin does. I'm using this quite alot myself when copying/backing up large masses of data between software...