import from sql backup

[kleoz]

can i import my phpBB2 forum database fro the .sql file in my pc ?

[BlueFlame]

Database schema is not the same between vBulletin and phpBB2. You need an Importer for that

[kleoz]

well my file is big 15mb and i cant upload it to any database so your importer could tranfer ... what should i do ?

[BlueFlame]

If your Host Allows Telnet, you can use SSH to upload your Database

[kleoz]

well it doesnt isnt there anywhere where i could upld the sql so i can import and then remove ... ?

[kleoz]

well lets say i uploaded in shell with mysql then what ? how i put it in the right place ? and where is the right place ?

[Steve Machol]

You need to restore the sql backup file to a database. Then you can run the phpBB importer.

[kleoz]

the problem is that i have database but my file is 15mb and the database cant upload that much it gets errors ...

[kleoz]

and lets say i managed to upload will the importer handle a 15mb database ?

[Guest]

Yes it will.

Your problem is most likely a timeout of some sort, let me guess, your trying to upload via phpmyadmin or something similar?

Your best bet is uploading the .sql file to your web server via ftp in a folder ABOVE the public folder. At which point you will be able to import via a number of scripts and bypass the timeout issues.

[kleoz]

explain this a bit better i didnt understand and yes i am trying via phpmyadmin

[Guest]

Php scripts may only run so long, most of the time this is set between 30 - 60 seconds. Basicly if you can not upload the .sql file in that amount of time the process will fail.

By uploading the file to the server via ftp, you bypass your bottleneak (your internet connection). Most scripts like phpmyadmin will allow to import from .sql files that are currently on your webserver. Most of the time it is as simple as typing in the path to the file on your server.

For example your path could be:

/www/mysite.com/dbbacks/phpbackup.sql

[kleoz]

what about yahoo ? how i should do it on yahoo ?

[kleoz]

could you please write me the command i should use to import file kleoz.sql ( backup ) to my mysql database via shell ? the ex user is Kleoz ans pass is pass write me the command i should use . the path to kleoz.sql is /home/kleoz/kleoz.sql

[Zachery]

You need to upload the file to the server then

mysql -uKleoz -ppass DATABASENAME < /home/kleoz/kleoz.sql

The only thing you need to do is make sure that your user has the create permissions or make a new database before running this command, then change the DATABASE name bit