Announcement

Collapse
No announcement yet.

import from sql backup

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • import from sql backup

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

  • #2
    Database schema is not the same between vBulletin and phpBB2. You need an Importer for that
    @Blu[email protected]

    Comment


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

      Comment


      • #4
        If your Host Allows Telnet, you can use SSH to upload your Database
        @[email protected]

        Comment


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

          Comment


          • #6
            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 ?

            Comment


            • #7
              You need to restore the sql backup file to a database. Then you can run the phpBB importer.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment


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

                Comment


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

                  Comment


                  • #10
                    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.

                    Comment


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

                      Comment


                      • #12
                        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

                        Comment


                        • #13
                          what about yahoo ? how i should do it on yahoo ?

                          Comment


                          • #14
                            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

                            Comment


                            • #15
                              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

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X