Grimpi IT Blog

agosto 29, 2008

Apuntes de como hacer un backup y restore en MySql

Filed under: Informatica, MySql — Etiquetas: , — grimpi @ 9:01 pm

Esto es un apunte mio, que lo dejo público para quien googlea y le pueda resultar útil. Como hacer un backup y restore desde la linea de comandos con MySql.

Backup:

mysqldump –host IP_DEL_SERVER –user USUARIO –opt DATABASE -p > BACKUP_NAME
(La opción –opt optimiza el proceso de backup y es recomenado su uso)

Restore:
mysql –host IP_DEL_SERVER -u USUARIO -p DATABASE < BACKUP_NAME

8 comentarios »

  1. Undeniably consider that that you stated. Your
    favorite justification appeared to be on the internet the easiest thing to consider of.
    I say to you, I definitely get irked at the same time as other folks consider concerns that they just don’t realize about. You managed to hit the nail upon the top as well as outlined out the entire thing with no need side-effects , other folks could take a signal. Will probably be again to get more. Thanks

    Comentario por yin yang — mayo 8, 2013 @ 12:09 am

  2. You will need to determine if it is the humidity and sweating that you are suffering from,
    as this can be relatively easy to fix. If you find that the area immediately around your house is very damp, you can add a gravel and limestone border, which will help with drainage.
    The first step in the process of maintaining a mosquito-free bedroom is to secure
    the structure of the house.

    Comentario por Joanne — mayo 14, 2013 @ 2:50 am

  3. There are many people moving on with the art of photography in the right manner.
    Sony Cybershot DSC S3000 reviews have made it
    a foremost choice for millions of mobile users. The Fujifilm Fine – Pix x100 is generally considered a professional compact rangefinder camera.

    Comentario por debt consolidation in florida — mayo 23, 2013 @ 8:08 am

  4. Hello, Neat post. There’s a problem with your website in internet explorer, would test this? IE still is the marketplace leader and a good component of other folks will pass over your magnificent writing due to this problem.

    Comentario por san leandro hotels — junio 4, 2013 @ 4:43 pm

  5. This slim and light tablet comes with specifications that
    provides high computing power. And with good reason because sometimes
    running an app on the big screen is nothing short of magical.
    Some manufacturers call their product a Cover while others use the
    name Case.

    Comentario por www.lindenchamber.net — junio 4, 2013 @ 7:27 pm

  6. 春の大掃除は内私アパートメントとしてとして、誕生日プレゼント。厳しいがにソリッドの面だけで少し穴はショーケース時間。でに私の意見では、このメソッド特色になりますグループ全体両方非常に最先端。彼女はを参照してクリムゾン カシミヤ織のセーターきちんと隠されたに、革素材スカート。 –
    ジェイコブ

    Comentario por ジェイコブ — junio 24, 2013 @ 12:07 pm

  7. Greetings from Colorado! I’m bored at work so I decided to check out your site on my iphone during lunch break. I love the knowledge you provide here and can’t wait to
    take a look when I get home. I’m surprised at how fast your blog loaded on my mobile .. I’m not even using WIFI, just 3G .
    . Anyways, fantastic site!

    Comentario por Get A Domain Name — julio 2, 2013 @ 7:10 pm

  8. super

    Apuntes de como hacer un backup y restore en MySql | Grimpi IT Blog

    Trackback por super — septiembre 21, 2014 @ 5:29 am


RSS feed for comments on this post. TrackBack URI

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s

Crea un blog o un sitio web gratuitos con WordPress.com.

A %d blogueros les gusta esto: