Backing Up And Restoring Your Mysql Database
|
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
About The Author
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
|
|
|
Microsoft Great Plains Ecommerce: Overview For Developer
Microsoft Business Solutions Great Plains was designed back in the earlier 1990th as first graphical ERP/accounting system for mid-size businesses. The architects of Great Plains Dexterity ? this is the internal mid-shell, all Great Plains was written on, designed it to be easily transferable between graphical operating systems (MAC, Windows, Solaris ? potentially) and database platforms ? initially Great Plains was available on Ctree (both Mac and PC) and Btrieve, a bit later high end version Dynamics C/S+ was available on Microsoft SQL Server 6.5. But the idea was to catch or switch winning/losing database platform ? nobody could predict if MS SQL Server, Oracle or DB 2 become a dominant DB platform, like Windows among OS. All these trade-ins for being potential...(related: Software)
C++ Tutorial 1, Introduction To C++
Introduction to C++Why Learn C++?C++ may at first seem like a boring, confusing programming language that you can only program command prompt applications with. Well, that is what it is like in the [b]begining[/b]. And you are going to need to l...(related: Software)
Dig Out That Worm
Internet worms.Is your PC infected?If your computer has become infected with a worm, don't panic, it is not the end of the world.There area number of things that you can do.Microsoft has a security web page.www.microsoft.com/security/default.mspxIt offers up to the minute information on the latest security threats and worms. It also provides you with all of the tools to dig out the worms and fix any damage that they may have caused.I expect that most of you are saying that you already have protection. May I ask a question?"Is it up-to-date?"We all know that ...(related: Software)
Syncup ? A File/folder Synchronizer For Windows
SyncUp, a file synchronizer is designed to assist the home and advanced users. The product has a simple and familiar windows explorer type interface for easy file handling. Further, the Scan Results provides a detailed preview of the files for synchronization.SyncUp has a flexible filter system to facilitate the user to change the sync direction, copy and delete files etc. while processing the synchronization. With scheduler the user can a...(related: Software)
Builders Beware
Which Type of Shop Can Rely On A Home Built System?Not all shops are at a disadvantage when it comes to building their own system. To determine which avenue a shop should take, owners must know what type of shops benefit from a self built solution and what type is better off purchasing one. Companies with a small number of people, where only 1 person estimates, prod...(related: Software)
Xml Parser And Their Types
XML parser is a software module to read documents and a means to provide access to their content. XML parser generates a structured tree to return the results to the browser. An XML parser is similar to a processor that determines the structure and properties of the data. An XML parser can read a XML document to create an output to generate a display form. There are a number of parsers available and a few of them are listed below:The Xerces Java ParserThe main applications of the Xerces Java parser is the building up of the XML-savvy web servers and to ensure the integrity of e-business data expressed in XML.expat XML parserThe expat XML parser is written in C and runs on UNIX or W32.The expat XML parser is not a validating proce...(related: Software)
Lotus Domino Implementation And Development: Infrastructure ? Present And Future
Domino server is a buffer between the operation system and the application. On the other hand Domino server ? consists of the services which support development processing and executing of dynamic, secure applications for Internet, Intranet, or Extranet. Domino server role is to provide functionality both: within and between Domino-applications....(related: Software)
Microsoft Great Plains Distribution, Barcoding, Consignment ? Overview For Consultant
Microsoft Great Plains ? ERM from Microsoft Business Solutions and formerly Great Plains Software is pretty generic with its standard set of modules: GL, BR, AR, AP, IV, SOP, POP and US Payroll. However, having about twelve years of implementation and customization history ? Great Plains Dynamics, Dynamics C/S+, eEnterprise being Great Plains Dexterity written application has been and still is attractive core platform for third party software development companies to write vert...(related: Software)
Is Software Tester A Most Infamous Person In A Software Project Team?
The fact that a software tester is a most infamous person in a software project team has some grounds underneath it...(related: Software)
Do You Want Your Own Fully Programmable Erp? - Part 1
We are in a transition phase in the Managerial Administration models of any company or Government, because three factors are summing for that:
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software