trying to move my phpbb database using phpmyadmin

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
187skillz
Forum Commoner
Posts: 39
Joined: Sun Aug 10, 2003 8:35 pm
Location: London

trying to move my phpbb database using phpmyadmin

Post 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
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post 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
187skillz
Forum Commoner
Posts: 39
Joined: Sun Aug 10, 2003 8:35 pm
Location: London

Post 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?
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post 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
187skillz
Forum Commoner
Posts: 39
Joined: Sun Aug 10, 2003 8:35 pm
Location: London

Post by 187skillz »

Is command prompt the same as Telnet access? sorry about the question, I know I've got Telnet access...

Thank you.
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post 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 ;)
187skillz
Forum Commoner
Posts: 39
Joined: Sun Aug 10, 2003 8:35 pm
Location: London

Post by 187skillz »

Yes...it's SSH actually, are u familiar with PuTTy client?
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post 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)
187skillz
Forum Commoner
Posts: 39
Joined: Sun Aug 10, 2003 8:35 pm
Location: London

Post 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.
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post 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 ;)
187skillz
Forum Commoner
Posts: 39
Joined: Sun Aug 10, 2003 8:35 pm
Location: London

Post 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?
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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...
187skillz
Forum Commoner
Posts: 39
Joined: Sun Aug 10, 2003 8:35 pm
Location: London

Post by 187skillz »

Thanks, I'll give that a shot
User avatar
liljester
Forum Contributor
Posts: 400
Joined: Tue May 20, 2003 4:49 pm

Post 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
Post Reply