Hi Everyone, I bought a blog from someone and installed WP on my server. The seller sent me the blog database SQL file, and all the other needed files. All the files were uploaded. Now... I don't know how to import the blog into my website. There's blog, but it's a new blog with no content.. I want to import the blog that used to be there before I bought it. Do I need a special sofware like SSH? or can I do it myself. If important details are missing, please reply and I'll give it to you. Thanks guys!
Hi reborn, as said, the old DB is 69MB... I can't upload it through phpMyAdmin... Any other suggestion? (the file is already on my website under 'blog' directory...) thanks
Break it into part? Access the old blog DB via phpMyAdmin and export tables separately, then import separately. Might work. I remember reading an article about importing huge DBs. Read this : http://www.theadminzone.com/forums/archive/index.php/t-28189.html http://www.jtpratt.com/2007/07/31/how-to-export-and-import-very-large-mysql-databases/
You have several options. If you have SSH access then copy the file over and use command line via SSH to import the DB that way. If you cannot do that, try upload it, send it to your host and see if they can run the commands in SSH for you. If not then I would break the SQL file down in to sections (2 - 3MB sections) and import each part at a time. It might take an hour or so to complete 69Meg but oh well To break it up, just open up the SQL file, copy and paste the first 1000 lines or so (maybe more maybe less) in to the import and hit go. Once they are imported do the next 1000 or so lines.
I once imported the HostingRefuge.com forum I purchased which was 120Mb. I did that through PHPMyAdmin and it took about 4 hours or so. Afterwards I noticed a command in the admin section which allowed you to delete the search indexes and recreate them. It took about 10 minutes to recreate them. That was the largest table to import. I wish I would have deleted them before and just re run the script to auto generate them. Oh well