1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Deciding to migrate, but...

Discussion in 'XenForo Questions and Support' started by Nasr, Oct 22, 2010.

  1. Nasr

    Nasr Well-Known Member

    I'm considering migrating my forums from vb 4.0 to xF. My only question here to you experienced webmasters, is, I have a database of about 200K posts, but it's almost 600m :S, dont know how it got that big. Anyway, I'm thinking of just importing the posts along with the users and not the attachments. Would you recommend I do this if I dont really care about the attachements?
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That is a perfectly valid way to go if you don't want to keep your attachments. Just run every import step except for attachments. There shouldn't be any problems.
    Jurhum likes this.
  3. Nasr

    Nasr Well-Known Member

    Thank you very much sir. Now, do you have any tip on uploading that 600M database to my local server beside using msql command cuz i cant seem to figure out how to use that consol unless u. I've tried bigdump and it gives me an error. i've tried phpmyadmin and it also times out. i've changed the max excution time to 3000 seconds but still times out. and i'm stuck wondering how to upload it.
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Using shell commands is really the best way to handle large databases. Here is the standard mysqldump command you can use to create a backup:

    mysqldump --opt -uUSER -pPASS DBNAME > backup.sql

    And here is the restore command:

    mysql -uUSER -pPASS DBNAME < backup.sql
  5. Nasr

    Nasr Well-Known Member

    ok, i'll try that, where does my backup.sql file have to be for it to work? in what directory, i'm using windows btw
  6. OperaManiac

    OperaManiac Well-Known Member

    you can try out http://www.heidisql.com/ which i use on my windows machine. it is a pretty solid alternative to phpmyadmin!
    Jurhum likes this.
  7. Nasr

    Nasr Well-Known Member

    i've downloaded that and i'm using it now, thanks..

    edit, it just gave me a connection lost error.. arrrr
  8. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    The commands for Windows are a little different. Here are the Windows commands with full paths specified.

    Backup command:

    "C:\PATH\TO\MYSQL\bin\mysqldump.exe" --opt -uUSER -pPASS DBNAME > "C:\PATH\TO\backup.sql"

    Restore command:

    "C:\PATH\TO\MYSQL\bin\mysql.exe" -uUSER -pPASS DBNAME < "C:\PATH\TO\backup.sql"
  9. borbole

    borbole Well-Known Member

    Can you also try to trim down the db by truncating the logs and seesion tables?
  10. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Yes, but the space savings is insignificant compared to pruning actual content like attachments.
  11. kkm323

    kkm323 Well-Known Member

    why would you do that while you can import everything using this importer
    it works great with me

    my only concerned are albums,thread tags, and thread prefix
    simple steps
    1. install new version of xenforo [yoursite.com/forum/install]
    2. then you need to import your old data from [Admin Control Panel > Tools >Import External Data ]
    3. just follow the steps so simple
  12. borbole

    borbole Well-Known Member

    I know what you mean but sometimes those tables get huge due to not being truncated. When I had done custom work I have seen them reach even 1 gb.
  13. mjp

    mjp Well-Known Member

    Why not move the attachments into the file system before you copy/migrate the database? Then you don't have a 600MB database to contend with.

    Attachments > Attachments Storage Type
    Blandt likes this.

Share This Page