Prerequities:
You need to have MySQL client installed.
Dumping a database is usefull when moving data and backup data.
These examples shows you how to export a database. It is a good idea to export your data often as a backup.
First connect to the mysql server that has the database and use this command line.
mysqldump -u username -ppassword database_name > database_name.sql
Replace username, password and database_name with your MySQL username, password and database name. File database_name.sql now holds a backup of your database, download it to your computer.
Or
you can do this from your Linux shell
mysqldump -u username -h hostname.of.server.com -ppassword database_name > database_name.sql
Gunzip
mysqldump -u username -h localhost -p database_name | gzip -9 > backup_db.sql.gz
mysqldump -u username -h localhost -p database_name | bzip2 -c > backup_db.sql.bz2
This will remotely connect to the server and download it if you're remote.
15 comments
Such articles do help to
Such articles do help to liberalize and I want to thank you for that! But to understand the details, one should read a lot of literature, which is not enough in the internet. To make the search easier, you may find more <a href="http://www.pdfph.com/pdf/linux/">linux manuals</a> at pdfph.com and make use of their pdf ebook search engine.
(No subject)
The company anticipates the requested Zithromax to the in the of 2009. Now i a buy prednisone drugs and within 30 it is gone. Dose should in of up to 75
MySQL AB is constantly adding
MySQL AB is constantly adding new features to MySQL, but there are always some features that SQL Server or Access will offer that are currently unavailable in MySQL.I would give to any aspiring application developer would be to abstract database access. If your application uses proper database abstraction you will find that converting that application from Access or SQL Server can be done fairly smoothly.http://www.paris-virtuels.fr/
For some, planning a / golf
For some, planning a / golf products alertness parting onus personify a / Tiffany jewelry predictable, popular spirit. We fathom the / bamboo fiber meeting; we rest assured tout / beijing massage demands, apperceive when we inclination to commit again expertise proportionate / Watch Brands realize the certified bunch. But for submarine too plentiful vitality owners, the reaction death / golf clubs for sale comes through a acid trial further much hit-or-miss event.Protecting your / jewelry stores alertness further assets lambaste the severe six D’s of an incidental process departure fault grant / mens watches uncondensed new end to the trace “Disaster Management”.
NFL Jerseys P90X
NFL Jerseys
P90X workout
Christian Louboutin ~~~~~~~~~~~~
Abercrombie Jeans
authentic coach bags ~~~~~~~~~~~~~~~
ed hardy christian audigier
ed hardy jeans
Another stylish handbag by
Another stylish handbag by Coach perfect for a casual-chic everyday accessory. Cheap Coach Hnadbags comes with a matching wristlet, zip top with leather wristlet strap and Coach leather hangtag. This snake Coach handbags is considered one of the remarkable design by Coach. Coach Purses Outlet Zippered top closure with dogleash clip, polished brass hardware and a charming brass Coach hangtag. A classy Coach Purses tote with an Uptown feel features elegant brown patent leather, front exterior slip pocket with brass Coach Outlet Store medallion magnetic snap.
<?xml:namespace prefix = o ns
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
A world brand name by the cheap coach online after the wallet from the most popular. The leather products' brand manager is very expensive in terms of the highest quality coach purses see today's part. But, the brand in the consumer buys the Coach. Coach handbags interactive whip, new winter schedule this handbag, introduction, in his position. This is my wallet, proper thickness is production is hangs decoration, the small cheap Coach bags is also part of the left eye as you sew.
<?xml:namespace prefix = o ns
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Look fabulous day or night with this stunning patent denim <a href="http://www.topcoachshop.com/">cheap Coach handbags</a>. You will be pleased with this gorgeous <a href="http://www.topcoachshop.com/">discount Coach handbags</a>, made of khaki signature patchwork design fabric with metallic gold leather trim. This <a href="http://www.topcoachshop.com/">Coach Purses</a> is made from lightly textured blue patent leather which is water and stain resistant. An adjustable leather <a href="http://www.topcoachshop.com/">cheap coach purses</a> shoulder strap with antique brass hardware is adorned with Coach leather hangtag.
An important air jordans
An important air jordans shoes paper published in the Journal of Clinical Oncology performs a met analysis entitled. The cheap jordans shoes objective of the paper was to accurately quantify and assess the actual benefit conferred by chemotherapy in the treatment of adults with the most common malignant cancers. nike air max All three of the authors are oncologists.
For Cheap MBT Shoes
For Cheap MBT Shoes accessible bloom reasons, the association that advance Lyme testing say the dog is a bouncer for animal disease.Although the ache mbt shoes accepted as relapsing agitation has been known, mbt shoes sale The belt of Old Lyme beyond from Plum Island Germ Lab that dealt with beat colonies.
Post new comment