HowTo

Newest Downloads

Mar.18

  [zenoss@zenoss2 ~]$ python Zenoss_Template_Manager.py -husage: Examples: python Zenoss_Templa...

How to restore a MySQL Database
Database HowTo's - MySQL HowTo's
Written by Allen Sanabria   
Saturday, 09 February 2008 23:58
Tags:

Now that you know how to backup your database,I will show you how to restore it on another database.
    1. The most common and basic way to restore, is a restore of a database.
    • mysql -u test1 --password=pass1 world < world.sql
    2. How about restoring your database to another database over the network with out logging into that box...
    • mysqldump -u test1 --password=pass1 world | mysql --host=170.20.10.32 -C world

Add this page to your favorite Social Bookmarking websites
Reddit! Del.icio.us! Mixx! Free and Open Source Software News Google! Live! Facebook! StumbleUpon! Yahoo! Free Joomla PHP extensions, software, information and tutorials.
Tags:
Comments
Search RSS
Only registered users can write comments!

3.22 Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."

< Prev   Next >
Last Updated on Wednesday, 14 May 2008 11:55