WordPress database installation

  • Hello Friends,

    I have a small issue like I have been working on my project for the last three four months on “LocalHost” with Microsoft webmatrix 3 platform.

    Now I have taken a hosting package and want to run/publish it. Could anyone guide me that how can use or Import or Export my database to online server or any pluging that will help me to import this database as it is?

    Please help.

    Thank you

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

  • Hello,
    As far as I understand you need a way to migrate your site from localhost to live server. Try this plugin Duplicator. It is quite straight forward and has a nice video guide how to work with it.

    Cheers and wish you luck

    Thread Starter sproficiency

    (@sproficiency)

    Thank you for the guidance. I downloaded and tried to make a database/package but it is not working. It keeps scanning but it doesn’t respond after this. I tried thrice but it didn’t help me at all.

    It took more than an hour to scan single period and after this it returns back to Setup package.

    Please help on the same.

    Have you tried looking for documentation for how export a database from Webmatrix? That might be the problem.

    Thread Starter sproficiency

    (@sproficiency)

    They also do not have much information on it. It helps in exporting the database and web deployment but doesn’t talk about the integration part.

    And this is why I didn’t prefer the Godaddy Hosting. FTP deployment is not working at all and web deployment integration is always an issue specailly with godaddy.

    I just need a wordpress pluging that can copy/clone/import and export the database.

    you can take the back up of your database using the php code.
    to find this code use this following link.

    https://www.tutorialspoint.com/php/perform_mysql_backup_php.htm

    Here is another solution for you:
    https://www.ads-software.com/plugins/wp-migrate-db/\
    It exports your DB only and also have a nice tutorial how to work with it. Before moving to duplicator i was working with this one.
    Hope this will help you.

    Thread Starter sproficiency

    (@sproficiency)

    WP Migration DB, All-in-one WP Migration, Duplicator, WP Clone, Multisite clone duplicator, Upload to FTP, and other manual option tried, but nothing is working at all.

    All show progress and after sometime, they go blank..

    Try this plugin: Adminer

    https://www.ads-software.com/plugins/adminer/

    This will create a database export (dump) that you can then import into your hosted database.

    Once installed and activated, it will be under the Tools menu.
    – select Adminer
    – click ‘Start Adminer insider’ or ‘Start Adminer in new tab’
    – in the left sidebar, click ‘Dump’
    – in ‘Output’, select ‘Save’
    – make sure ‘Format’ is ‘SQL’
    – click ‘Export’
    – an SQL file will be saved to wherever your downloads are saved

    This is the file that will be imported into the new, empty database that you will create on your web host.

    Once you import it, you will need to edit the ‘siteurl’ and ‘home’ fields of the wp_options table with your live, website domain name, e.g.:

    https://www.my_domain.com

    That’s the ‘database part’ ??

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘WordPress database installation’ is closed to new replies.