Fashion Buzz - All About Style and Beauty: database backup

Showing posts with label database backup. Show all posts

Website Transfer(Part-6, Database configuration)

Hello friends. If you following my blog and all the previous posts about website transfer to a new hosting, now your have a clear idea about this process. Let me refresh again.

Here comes the last and final step. Now your just have to configure your new website and database properly its called "database configuration". Lets start.

If you are using Wordpress for your website log in to you hosting account and open the file manager. Here your will find your domain folder (if you use a addon domain otherwise go for the root), open that than your will find a file named "wp-config.php". This is the database configuration file. This file contain the database name, database user name and password. Select this file and open this file with "Code Editor" from the top tool bar.

Database configuration

Now check the code editor for the "wp-config.php" file. It will look almost the same as the below picture.

wp-config.php file

Here you will find the Data base name (DB_NAME) here your have to add your newly created database.
In the next line there will be database user name (DB_USER) here add the user name of your newly created database and next your have to add database password (DB_PASSWORD).

Now its done. All the process of website transfer to a new hosting is completed. Enjoy!

Website Transfer(Part-5, Backup Database upload and Configure)

By 8:50 AM No comments:

To Transfer your full website to a new hosting is little bit tricky. But it will look very easy just read my previous posts. In my Last post I showed you hot to create a new database for your website. Now I will show you How to Update your backup database to this newly created database.

First Step: Log in to your cPanel and go for "phpmyadmin" on Database section. It will redirect you to your mysql.

"phpmyadmin" on Database section

Second Step: Now your are redirected to "phpmyadmin", here in the left panel you will find your recently created database (for more information about creating new database, check my previous article). Click on your database, after selecting your database in the right panel it will show nothing because your new database does not contain any table, row or any data. Now we will add your old backup database here.

Third Step: Now select your newly created database from the left panel, it will show nothing. Now click on the "Import" button from the top tool bar. Now just select your old database backup file from your computer and go for the upload process.

Import new database

After finishing the uploading process it will show all the data from your old data from your old web page. All data in now added to your new web site database.

Now the final step you have to configure your new database to work it properly.

Look for my next article, there I will show your all the details about database configuration. Thanks!

Website Transfer(Part-4, Creating new mysql database)

By 12:01 PM No comments:

If you read my previous posts, Now you know how to make a website files and database back and learned about files and folder upload. Here I will show you the final step "Backup Database upload and Configure."

To Upload your old database to your new hosting for your website your have to create a new database first.

Log in to your cPanel and go for the "MySQL® Database Wizard" Button on the "Database" Section of your cPanel.
In "MySQL® Database Wizard" You have to provide a name of your new database. Remember if you have more than one website and database its better to give your database your website related name. So that in future your will not get confused with your database.


MySQL® Database Wizard

After naming your database "ontest" you have to go to the next window. There your have to provide a username and password for your database. (Password can be created automatically). Just follow the below picture....

MySQL® Database Wizard for user name and password

After creating Database user and password than comes User PRIVILEGES section. You have to provide User PRIVILEGES here. Its better if you using your own website and database select "All PRIVILEGES" so that you will get the full control of your database and website.

Database User PRIVILEGES

Now your have successfully created your new Database. Before going to the next step please save your database name, database user name and database password in a notepad file. To configure your uploaded database it will require.

Please follow my next article, there I will show your "Backup Database upload and Configure."

Website Transfer(Part-3, Files and Folder Upload)

By 2:47 AM No comments:

If checked my previous posts, now you can Backup files and folders of website and Your also can make Database Backup of a Website. What to do now? Don't worry, I will guide you through.

Uploading Files and Folders of your website

Login to your Hosting server cPanel and go for the "File Manager".
If your this domain is the main domain "File Manager" will be empty. But if this domain you added as an "Addon Domain" you will see a folder named after your addon domain, just open that folder.
At the top tool bar there will be a "Upload" button, Click on that.

Upload Button on cPanel

Now comes the Upload section, where you have to provide the .zip backup folder location and Uploading will start automatically.

After finishing the uploading go back to the "File Manager" and you will find your compressed folder. Select your Compressed folder and click on the "Extract" button and all the files and folder of your website will be Extracted.

This ends the files uploading your your website. Now comes the database uploading act. Because without the database and the database configuration your website will not work. Let starts with the database uploading first and I will show you the database conflagration.

Check my next Article. There I will show your how to create a new database for your new website and how to Uploading your old database Backup to your new hosting.

Website Transfer(Part-2, Database Backup)

By 1:52 PM No comments:

In my Last article I have shown you how to create backup archive of all the files and folders of your website.

Transfer Your Website to a New Hosting (Part-1)

In this article I will show your how to create a Database back up of your website.

First log in to your cPanel and you will find a "Database" section. Click on the "phpMyAdmin" Icon and it will redirect you to your mysql database. Here you will find the database of your website. If you have only one website in this hosting, you will find in the left panel the only one database. If you hosting multiple website, you will see all the database of other website. Look for the database you want to backup and click on it.

phpmyadmin in the cpanel

After selecting you desired database in the right panel all the row and data will display. In the right panel tool bar you will find a button named "Export" . Click there and you selected database will prepare to make a backup. Just go for it. This process will save a notepad file with a .sql extension.

mysql Database

This is the full database back up of you website. Now you just have upload this file to your new mysql of your hosting and configure it properly to run your website.

In my next article I will show you the how to upload website files and back up database. Enjoy!