Page 1 of 1
trying to move my phpbb database using phpmyadmin
Posted: Thu Apr 08, 2004 11:12 am
by 187skillz
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
Posted: Thu Apr 08, 2004 11:22 am
by JayBird
extract the phpbb__db__backup3[1].sql.gz using winzip and you will be left with a sql file. Import that and it should work.
Mark
Posted: Thu Apr 08, 2004 12:20 pm
by 187skillz
thanks, I tried that and I'm still getting the message
No SQL query!
This is the new file name which is just a text.
phpbb__db__backup3[1].sql
Still not working!
any idea pls?
Posted: Thu Apr 08, 2004 12:23 pm
by markl999
I've had that error a few times using phpMyAdmin (and large .sql files) so i just don't bother and use the command line now.
If you have access to a command prompt on the server then just upload the file and do :
mysql -u username -p thedbname < phpbb__db__backup3[1].sql
Posted: Thu Apr 08, 2004 4:02 pm
by 187skillz
Is command prompt the same as Telnet access? sorry about the question, I know I've got Telnet access...
Thank you.
Posted: Thu Apr 08, 2004 4:07 pm
by markl999
Well, i was thinking more of SSH, i thought telnet was banned in the 80's (it should have been), but yeah, telnet should do the job

Posted: Fri Apr 09, 2004 9:47 am
by 187skillz
Yes...it's SSH actually, are u familiar with PuTTy client?
Posted: Fri Apr 09, 2004 12:10 pm
by markl999
Yeah. Just connect using the hostname, user and password that your host should have provided, then you should be able to run the command i gave above. To get the .sql file onto the server you could use scp, there's awindows client called WinSCP if i remember correctly (there's probably others too)
Posted: Sat Apr 10, 2004 6:41 am
by 187skillz
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.
Posted: Sat Apr 10, 2004 6:45 am
by markl999
I hope I don't <span style='color:blue' title='I'm naughty, are you naughty?'>smurf</span> you off Mark or anyone
Not at all
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

Posted: Sun Apr 11, 2004 7:11 am
by 187skillz
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?
Posted: Mon Apr 12, 2004 12:30 pm
by JAM
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...
Posted: Wed Apr 14, 2004 1:47 am
by 187skillz
Thanks, I'll give that a shot
Posted: Wed Apr 14, 2004 7:59 am
by liljester
if you can use the mysql from a command line, login, switch to your database (or create one, and switch to it) and use the "source c:\path\file.sql" to your file, and itll work like a charm