Home

Feature Article:

The Benefits of the New Firefox Browser
You probably heard of the new Firefox browser version 1.0 recently released by Mozilla. If you are currently using Internet Explorer or Netscape, you are probably wondering if Firefox is better and why is it better. In order to answer these...
...Read More


Backing Up And Restoring Your MySQL Database

Additional Reading


If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.

Backing up your database

The quickest and easiest way to backup and restore your database would be to use MySQLDump. If you've got shell or telnet access to your server, you can backup MySQL data by issuing the mysqldump command. The syntax for the command is as follows.

mysqldump -u [uname] -p [pass] [dbname] > [backupfile.sql] [uname] - this is your database username [pass]- this is the password for your database [dbname] - the name of your database [backupfile.sql] - the filename for your database backup

To backup your database 'Customers' with the username 'sadmin' and password 'pass21' to a file custback.sql, you would issue the command

mysqldump -u sadmin -p pass21 Customers > custback.sql

Issuing this command will backup the database to custback.sql. This file can be copied to a safe location or a backup media and stored. For more information on MySQLDump, you can check out : http://www.mysql.com/doc/en/mysqldump.html

Restoring your database

If you have to re-build your database from scratch, you can easily restore the mysqldump file by issuing the following command. This method will not work if the tables already exist in your database.

mysql - u sadmin -p pass21 Customers < custback.sql

If you need to restore existing databases, you'll need to use MySQLImport. The syntax for mysqlimport is

mysqlimport [options] database textfile1

To restore your previously created custback.sql dump back to your Customers Database, you'd issue

mysqlimport -u sadmin -p pass21 Customers custback.sql

For more information on MySQLImport, you can check out : http://www.mysql.com/doc/en/mysqlimport.html

Vinu Thomas is a consultant on Webdesign and Internet Technologies. His website is http://www.vinuthomas.com. You can discuss about this article or any PHP/MYSQL related issues in our Discussion Forums: http://www.vinuthomas.com/forum2.html

 

More Reading:


Microsoft CRM Development

Sticky Sites Rule The Internet

How to Protect your PC from Spyware in the Cyber Age

Create Your Own Webcomic

Eight Quick Tips For Stopping SPAM

 
GigaSlot Wireless Gaming Platform

Cisco CCNA Certification The Joy Of Hex

Computers and Web Cams are Taking Communication to Levels Only Imagined in Sci Fi Novels

MSN PPC Advertising Behavioral and Demographic Targeting Killer App or Achilles Heel

Secrets of Writing a Business Website Homepage


Microsoft CRM Development
Microsoft CRM is CRM answer from Microsoft Business Solutions. The whole conception behind CRM seems to be different. In case of traditional CRM software (Siebel, Oracle) - the application was designed with platform independence in mind....
...Read More

Sticky Sites Rule The Internet
Read through the hundreds of forums and bulletin boards on the internet and you will find dozens of threads centering on the lack of web site traffic. All the other remaining threads bemoan the difficulty of getting visitors to return long enough...
...Read More

How to Protect your PC from Spyware in the Cyber Age.
Wouldn't you be shocked to find that your personal sensitive information, like files, credit card information, operating system / software and other non-disclosed data to be penetrated by unscrupulous prying eyes? Even worse... "Is your...
...Read More

Create Your Own Webcomic
Syndicated comic authors have been complaining about newspaper size restrictions, content censoring and similar issues for a long time. Comic enthusiasts have been increasingly irritated by the treatment their entertainment medium receives as...
...Read More

Eight Quick Tips For Stopping SPAM
If you are buried in SPAM then you're not alone. It's been suggested that as much as 50% to 75% of the e-mail traffic on any given day is SPAM. Reading through SPAM is a waste of your time and it subjects you to potential viruses, trojan horses,...
...Read More