Where to find MySQL?

  • Hi I have changed hosting companies from Site 5 to Fatcow.

    I downloaded all of my files from Site 5 and have now uploaded them to Fatcow.

    Everything in my folder public_html with Fatcow is exactly the same as before but none of my posts/ pages / text or anything appear on my website.

    I have contacted Fatcow and they have given me this response:

    “Wordpress stores most of the content and settings in a MySQL database. The database currently on your account has no content beyond the defaults. The WordPress files are just skeletal framework for the content. The pages and posts are all stored in a MySQL database. If you can provide us with a dumpfile, we can import it for you.”

    Can I find the MySQL database in my public_html folder?

    The subfolders are wp, wp-admin, wp-content, wp-includes.

    Thanks

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

  • Review Moving_WordPress.

    No the “MySQL database” is not located in the public_html folder. Its a separate server outside of any html or php files. If you are on a shared hosting you need to ask them how to access your MySQL. It could very well be in your cpanel somewhere.

    Mysql database are normally in phpmyadmin and you need export the database save as file and import in your new host phpmyadmin

    1. Login to your hosting provider Cpanel, and make a full backup.
    2. Download the backup
    3. In the backup there should be a *.sql file, which is your database export. The name of the file should be the name of the database.
    4. Login to your new hosting provider Cpanel.
    5. From the databases section, select phpMyAdmin.
    6. Create a database with the same name, and using the import option, import the *.sql file from your previous hosting provider backup.

    few ways to backup wordpress an install it on new hosting, most easy for you will be ask you hosting provider to help you, bc as I see you dont know even about mysql

    Hi Dryicenz,

    You just login to your Site 5 host cpanel and then got to phpmyadmin.
    There you can find the database where your wordpress is installed. Click o the database name and click EXPORT then it will be downloaded as *.sql file. This is very important file which will be used to restore all the wordpress data to new bluehost server.

    Hope it helps. If you are facing trouble in doing that just let me know I can do it for you. Don’t worry I won’t charge anything, it is my passion to help.

    Thanks

    Do you have a control panel?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Where to find MySQL?’ is closed to new replies.