Add to Favorites     Get Paid to Participate     Twitter     Facebook     Google+
Hosting Discussion
 

Hosting Discussion > Web Hosting Forums > Web Hosting Discussion > Backup of Mysql database using PhpMyAdmin
forgot password?


Reply


Old
  Post #1 (permalink)   06-26-2009, 06:00 AM
HD Newbie
 
Join Date: Jun 2009
Posts: 11

Status: holhostcom is offline
Backup of Mysql database
It is assumed that you have phpMyAdmin installed since a lot of web service providers use it.

0. Open phpMyAdmin.
1. Click Export in the Menu to get to where you can backup you MySql database. Image showing the export menu.
2. Make sure that you have selected to export your entire database, and not just one table. There should be as many tables in the export list as showing under the database name.
3. Select"SQL"-> for output format, Check "Structure" and "Add AUTO_INCREMENT" value. Check "Enclose table and field name with backquotes". Check "DATA", check use "hexadecimal for binary field". Export type set to "INSERT".
4. Check "Save as file", do not change the file name, use compression if you want. Then click "GO" to download the backup file.

Restoring a backup of a MySql database
1. To restore a database, you click the SQL tab.
2. On the "SQL"-page , unclick the show query here again.
3. Browse to your backup of the database.
4. Click Go.
__________________
HolHost.com
 
 
 


Old
  Post #2 (permalink)   06-26-2009, 10:39 AM
HD Addict
 
LaneHost's Avatar
 
Join Date: Mar 2007
Location: Houston, TX
Posts: 153

Status: LaneHost is offline
Thanks for the info, I would also like to add that while this may work for some it may not work for all databases as bigger databases may be too big and timeout.

If you have SSH access, then you can do a mysqldump which is a safer bet. You can also ask your web host to do this for you if you do not have access generally or are not comfortable with doing this.

mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

# [username] - this is your database username
# [password] - this is the password for your database
# [databasename] - the name of your database
# [backupfile.sql] - the file to which the backup should be written.
__________________
LaneHost Solutions, Inc. | Professional Web Hosting Solutions
Affordable Shared Hosting, Reseller Hosting & Dedicated Servers at Great Prices!
Complete Solution To Affordable Reseller Web Hosting

Follow us on Twitter! | The LaneHost Blog | LaneHost Forums
 
 
 


Old
  Post #3 (permalink)   06-27-2009, 05:04 AM
HD Amateur
 
Join Date: Oct 2008
Posts: 66

Status: hzSari is offline
mysqldump do have many options like --compatible=mysql40 while transferring to older versions too.
__________________
hzSari | HostingZoom.com
ModVPS.com | ResellerZoom.com
Power Speed Reliability
 
 
 


Old
  Post #4 (permalink)   06-27-2009, 09:06 AM
HD Newbie
 
Join Date: Jun 2009
Posts: 7

Status: jone is offline
this is good article can be use to back up my profession, can i print it?
__________________
____________________________________
█ | TLS-CORPORATION.COM |Is Not Just Hosting Partner.
TLS-CORPORATION is World Class Hosting Partner Providing adequate service for SMALL organization to GROW
 
 
 


Old
  Post #5 (permalink)   06-27-2009, 02:04 PM
Reseller Specialist
 
Join Date: Mar 2009
Location: New York
Posts: 461
Send a message via AIM to XeHSean Send a message via MSN to XeHSean

Status: XeHSean is offline
Just a reminder, you can also easily backup Mysql databases in cPanel (for those who use it)
__________________
XeHost.net - Hosting websites since 1999!
Shared Hosting, Reseller Hosting, VPS Hosting, and Dedicated Servers
End-User Support, WHMCS, and WHMReseller for Reseller Hosting Packages!
Follow us on Twitter - new special every Sunday! @XeHost
 
 
 


Old
  Post #6 (permalink)   06-29-2009, 04:28 AM
HD Addict
 
Join Date: Apr 2009
Posts: 216

Status: rumsfo is offline
Quote:
Originally Posted by XeHSean View Post
Just a reminder, you can also easily backup Mysql databases in cPanel (for those who use it)
You are right. But I assume they are the tips for the non Cpanel accounts or to be nore exact for non Cpanel backups.

Nice tips. They are obvious fo me but I assume someone will find them interesting
__________________
?Want FREE Windows 7 UE or Zune HD 32GB? - We will give it!
learn more how to get it...
****** Web Hosting - ASP.NET, MS SQL, AJAX, Hyper-V
Microsoft Hosting and Virtualization
 
 
 


Old
  Post #7 (permalink)   06-29-2009, 09:55 AM
HD Newbie
 
Host-REA's Avatar
 
Join Date: Apr 2009
Location: Ohio
Posts: 40

Status: Host-REA is offline
Thanks for the writeup.
__________________
Host-REA ~since 2007
Shared Hosting - Reseller Hosting - VPS Hosting
 
 
 


Old
  Post #8 (permalink)   07-01-2009, 11:41 PM
HD Newbie
 
Join Date: Jun 2009
Posts: 12

Status: neo666 is offline
thanks for the tip
just a question,even if out of context , how to publish mysql content
 
 
 
Reply

Thread Tools

New Post New Post   Old Post Old Post
Posting Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Sponsored By: