Creating an SQL Dump File

  • Hi,

    I have created a WordPress website an I just want to upload it now. I need an sql dump file. How do I create an sql dump file?

    I designed the website on my localhost and I created my database with WAMP Server.

    Could someone please help me on how to create an sql dump file which I can import onto my database online?

    Thanks,
    Rohan

Viewing 8 replies - 1 through 8 (of 8 total)

  • In your Wamp you should have phpmyadmin you export your database from there save as file and then import on your host phpmyadmin.

    Thread Starter RPMouton

    (@rpmouton)

    Thanks a mill! I finally got the sql dumpfile.

    Now everytime I try to import it into my phpmyadmin, it tells me:
    Bad Request
    Your browser sent a request that this server could not understand.

    Any ideas why this would be?

    Does the dump file need to have a specific name, or can you name it anything as long as it is an sql file?

    When you export the dump file in phpmyadmin you should have sql file saved on your computer and then and you import the same file.

    @rpmouton
    Can you paste here the exact message? Did you change all the URLs to match the site URL?

    Thread Starter RPMouton

    (@rpmouton)

    Hi Krishna,

    The message I pasted before is the exact message that displays. The two lines that I posted.

    Which buttons should be selected to export the sql file correctly?

    Did you export the database to your live site? Did you change the URLs in the database to match the site URL? Or did you import the database to the live site at all? The buttons on the live site are similar to the buttons on your WAMP server.

    Thread Starter RPMouton

    (@rpmouton)

    Hi,

    Ok, the sit site is mostly sorted, just a few niggles.

    I just want to make sure, when exporting the database from phpmyadmin, which of the buttons should I look out for that SHOULD be ticked, and which SHOULD NOT be ticked?

    It is a bit tricky. If you are not experienced, better do not try on a live site.

    You should know how to drop tables, then make the database with necessary changes ready for export from your computer, and then import it to the empty database. The tables will be automatically created.

    If you try to do all these things make sure you keep your database intact so that it can be used in case things go wrong.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Creating an SQL Dump File’ is closed to new replies.