Export / import SQL database (2 posts)

  1. Maraki
    Posted 3 years ago #


    Is their a proper way of exporting and importing the SQL database to a new database.

    When I tried to do that in the standard way I run into 2 issues:

    1. All widgets disappeared and I had to create them from scratch

    2. I had issues with special characters such as ' and I had to search and replace the gibberish letters

    This is quite important as I need to move to a managed server from shared hosting. All apache, php, MySQL versions will be the same.

    Ps: this will have to be SSH commands as phpadmin times out due to the database size.

    Many thanks,

  2. vtxyzzy
    Posted 3 years ago #

    Chances are that the problems are caused by serialized data in the database. Here is an article that discusses the problem and offers some tips on dealing with it: http://wpgarage.com/tips/data-portability-and-data-serialization-in-wordpress/

Topic Closed

This topic has been closed to new replies.

About this Topic