Skip to main content
LinuxMySQLOpen SourceSSHTrucos

Como Copiar una Base De Datos (MySQL) de un servidor a otro por SSH.

By 1 October 200713,257 Comments

Recientemente tuve este dilema ya que querí­a pasar la Base de datos de uno de mis servidores a otro, entendí­ que la manera mas fácil era atravez de SSH (shell/ Terminal) antes de esto siempre entraba a phpMyAdmin hacia un backup del la base de datos y luego entraba al panel de phpMyAdmin del otro servidor y la subí­a. Pero me encontré con un problema mas grande, al tratar de hacer esto en el nuevo servidor me daba un limite de solo subir por el upload “10MB” esto obviamente comprimido por que las base de datos pesaba “120MB” comprimido era unos “12MB” imaginen eso por solo “2MB” no podí­a subir una base de datos.

Recordé entonces el famoso mysqlDump que hace un backup de tu base, pero me pregunte aja eso es fácil lo mismo que puedo hacer atravez del Admin de MySQL el problema es como la paso al otro servidor para que la suba? Yo soy bien amante del “SCP” (Secure Copy) de Linux que es la manera mas fácil y segura de pasar archivos atravez de un red por SSH. Luego de tener idea de lo que querí­a y necesitaba me di a la tarea de buscar y luego de un rato encontré mi solución y salvación!

Este es el comando que debes utilizar

mysqldump -utuuser -pmolongo tudb | ssh [email protected] "mysql -upapanga -pplancheta -h mysql.vidanix.com tudb"

En palabras mas fáciles, lo que estamos haciendo aquí­ es ejecutar un MySQL Dump (backup de db y luego transferir esta data a nuestro otro servidor por SSH y además de esto decirle que lo vamos a subir con el siguiente user y password en la siguiente tabla utilizando el siguiente subdominio. Si te fijas bien casa user y password esta empezado por el comando -u ó -p luego de esto pones el username o password todo corrido, sin espacios igualito a como aparece en el ejemplo. En algunos casos al pasar la base de datos a otro servidor nuestro proveedor tiene un servidor exclusivo de MySQL por eso al final hice referencia a -h (hostname) de ser “localhost” solo elimina la -h y listo. Ya tienes como hacer backup de una base de datos a otra todo por SSH, quien dijo que por GUI era mas fácil?

*Asegura-te de haber creado el db con el nombre que de-ses y el usuario antes de ejecutar este comando si no, no obtendrás ningún resultado.

Ultimos 10 Temas Por Ernesto

13,257 Comments

  • Lloydphics says:

    To save on pharmacy costs, I recommend visiting this resource. It shows prices for generics. Best prices available here: ?»?https://polkcity.us.com/# mexican medicine store.

  • Danielgluct says:

    ?»?To be honest, I stumbled upon an interesting report regarding ordering meds from India. It explains CDSCO regulations for ED medication. If anyone wants Trusted Indian sources, go here: ?»?reading. Good info.

  • RichardFek says:

    Heads up, an important guide on FDA equivalent standards. It explains quality control for generics. Full info: ?»?mexico pharmacy.

  • RichardFek says:

    Has anybody tried safe Mexican pharmacies. I ran into a cool archive that compares trusted vendors: ?»?mexico pharmacies. What do you think?.

  • Ralphhiere says:

    ?»?Just now, I found a helpful article concerning Indian Pharmacy exports. It explains WHO-GMP protocols for ED medication. If anyone wants Trusted Indian sources, go here: ?»?https://kisawyer.us.com/# Online medicine home delivery. Hope it helps.

  • Danielgluct says:

    ?»?Just now, I found a helpful guide concerning ordering meds from India. It details WHO-GMP protocols for ED medication. If anyone wants cheaper alternatives, read this: ?»?see more. Good info.

  • Danielgluct says:

    ?»?Recently, I came across a helpful report concerning buying affordable antibiotics. It details the manufacturing standards for generic meds. If anyone wants Trusted Indian sources, go here: ?»?kisawyer.us.com. It helped me.

  • RichardFek says:

    For those looking to save money on prescriptions, I suggest checking this resource. It shows trusted Mexican pharmacies. Huge savings available here: ?»?polkcity.us.com.

  • RichardFek says:

    ?»?Lately, I found a great guide regarding Mexican Pharmacy standards. It details regulations when buying antibiotics. In case you need affordable options, visit this link: ?»?polkcity.us.com. Might be useful.

  • Ralphhiere says:

    ?»?Actually, I came across an informative resource about Indian Pharmacy exports. It details how to save money when buying antibiotics. In case you need reliable shipping to USA, go here: ?»?kisawyer.us.com. Good info.

  • Danielgluct says:

    ?»?Just now, I came across an informative resource about buying affordable antibiotics. It covers CDSCO regulations for generic meds. If anyone wants factory prices, take a look: ?»?kisawyer.us.com. Good info.

  • Danielgluct says:

    ?»?Actually, I stumbled upon a great page about generic pills from India. It covers the manufacturing standards on prescriptions. If anyone wants Trusted Indian sources, read this: ?»?kisawyer.us.com. Worth a read.

  • Lloydphics says:

    To save money on prescriptions, I suggest reading this archive. It reveals prices for generics. Good deals at this link: ?»?Upstate Medical.

  • RichardFek says:

    ?»?Just now, I discovered a useful guide regarding buying affordable antibiotics. It explains FDA equivalents on prescriptions. If you are looking for affordable options, check this out: ?»?mexico city pharmacy. It helped me.

  • Lloydphics says:

    If you want to save big on pills, you should try checking this resource. It shows prices for generics. Huge savings available here: ?»?here.

  • Ralphhiere says:

    ?»?Actually, I discovered a great resource regarding ordering meds from India. The site discusses CDSCO regulations for ED medication. For those interested in Trusted Indian sources, read this: ?»?kisawyer.us.com. Cheers.

  • Ralphhiere says:

    ?»?Lately, I discovered a useful article about buying affordable antibiotics. It covers CDSCO regulations on prescriptions. If anyone wants cheaper alternatives, visit this link: ?»?kisawyer.us.com. It helped me.

  • Danielgluct says:

    ?»?Just now, I came across a great article about buying affordable antibiotics. The site discusses the manufacturing standards for generic meds. If you are looking for cheaper alternatives, take a look: ?»?https://kisawyer.us.com/# top online pharmacy india. Might be useful.

  • RichardFek says:

    ?»?Lately, I stumbled upon an informative report regarding safe pharmacy shipping. The site discusses the safety protocols on prescriptions. If you are looking for affordable options, go here: ?»?polkcity.us.com. Hope it helps.

  • Ralphhiere says:

    ?»?Lately, I discovered an interesting resource about generic pills from India. It covers CDSCO regulations for generic meds. If you are looking for reliable shipping to USA, go here: ?»?https://kisawyer.us.com/# top online pharmacy india. Might be useful.

  • Ralphhiere says:

    ?»?Actually, I discovered an interesting article regarding generic pills from India. The site discusses CDSCO regulations when buying antibiotics. If you are looking for cheaper alternatives, visit this link: ?»?https://kisawyer.us.com/# buy medicines online in india. Cheers.

  • RichardFek says:

    To save big on pills, you should try visiting this report. The site explains shipping costs. Best prices found here: ?»?Upstate Medical.

  • Danielgluct says:

    ?»?Lately, I came across an informative resource regarding Indian Pharmacy exports. The site discusses WHO-GMP protocols on prescriptions. If anyone wants Trusted Indian sources, visit this link: ?»?best online pharmacy india. Worth a read.

  • RichardFek says:

    Quick question about ordering meds from Mexico. I ran into a decent site that ranks safe places: ?»?Upstate Medical. Looks legit.

  • Ralphhiere says:

    ?»?Actually, I found a helpful page regarding generic pills from India. It details how to save money for ED medication. In case you need Trusted Indian sources, take a look: ?»?https://kisawyer.us.com/# online shopping pharmacy india. Worth a read.

  • Ralphhiere says:

    ?»?Recently, I stumbled upon an informative article about generic pills from India. It covers the manufacturing standards for generic meds. If you are looking for factory prices, take a look: ?»?follow. Hope it helps.

  • Danielgluct says:

    ?»?Recently, I discovered an interesting report concerning Indian Pharmacy exports. It explains WHO-GMP protocols when buying antibiotics. For those interested in Trusted Indian sources, take a look: ?»?https://kisawyer.us.com/# ?»?legitimate online pharmacies india. Good info.

  • RichardFek says:

    Does anyone know buying generic pills online. I found a verified blog that ranks best pharmacies: ?»?https://polkcity.us.com/# farmacias online usa. What do you think?.

  • Lloydphics says:

    Just wanted to share, a detailed analysis on Mexican Pharmacy safety. It explains how to avoid scams for generics. Source: ?»?polkcity.us.com.

  • RichardFek says:

    ?»?Lately, I stumbled upon a great article regarding safe pharmacy shipping. The site discusses regulations for ED medication. If you are looking for reliable shipping to USA, read this: ?»?order meds from mexico. Good info.

  • Ralphhiere says:

    ?»?Actually, I found a helpful guide regarding cheap Indian generics. It covers WHO-GMP protocols for generic meds. If you are looking for reliable shipping to USA, visit this link: ?»?https://kisawyer.us.com/# reputable indian pharmacies. Cheers.

  • Ralphhiere says:

    ?»?To be honest, I came across an interesting guide regarding buying affordable antibiotics. It covers the manufacturing standards for ED medication. In case you need Trusted Indian sources, take a look: ?»?india online pharmacy. Good info.

  • Danielgluct says:

    ?»?Recently, I found an informative page regarding ordering meds from India. It details the manufacturing standards for ED medication. For those interested in factory prices, take a look: ?»?kisawyer.us.com. It helped me.

  • Danielgluct says:

    ?»?Just now, I stumbled upon a useful guide regarding cheap Indian generics. It covers the manufacturing standards on prescriptions. For those interested in factory prices, read this: ?»?https://kisawyer.us.com/# top 10 pharmacies in india. Good info.

  • Ralphhiere says:

    ?»?Recently, I stumbled upon an interesting guide about generic pills from India. It covers CDSCO regulations for ED medication. For those interested in cheaper alternatives, check this out: ?»?homepage. It helped me.

  • RichardFek says:

    Does anyone know safe Mexican pharmacies. I discovered a verified blog that reviews safe places: ?»?https://polkcity.us.com/# mexico drug store online. Check it out.

  • Ralphhiere says:

    ?»?Lately, I came across a useful report regarding buying affordable antibiotics. It explains the manufacturing standards for ED medication. For those interested in Trusted Indian sources, take a look: ?»?https://kisawyer.us.com/# online shopping pharmacy india. Hope it helps.

  • Danielgluct says:

    ?»?To be honest, I stumbled upon a great resource about generic pills from India. It covers CDSCO regulations for generic meds. If anyone wants reliable shipping to USA, take a look: ?»?kisawyer.us.com. Might be useful.

  • RichardFek says:

    Does anyone know buying generic pills online. I found a decent site that lists trusted vendors: ?»?mexico drug store. Seems useful..

  • Danielgluct says:

    ?»?Just now, I found a great article concerning ordering meds from India. The site discusses the manufacturing standards on prescriptions. If anyone wants reliable shipping to USA, take a look: ?»?reading. Worth a read.

  • Lloydphics says:

    For those looking to save on pharmacy costs, I suggest reading this resource. The site explains where to buy cheap. Best prices at this link: ?»?official site.

  • Lloydphics says:

    For those looking to save on pharmacy costs, I suggest reading this page. It reveals shipping costs. Huge savings found here: ?»?mexico pharmacy price list.

  • Ralphhiere says:

    ?»?To be honest, I came across an informative guide regarding generic pills from India. It details WHO-GMP protocols for ED medication. If you are looking for cheaper alternatives, check this out: ?»?check here. Worth a read.

  • RichardFek says:

    Has anybody tried safe Mexican pharmacies. I discovered a verified blog that ranks safe places: ?»?https://polkcity.us.com/# mexico pharmacy list. Check it out.

  • Ralphhiere says:

    ?»?Actually, I came across a useful guide concerning Indian Pharmacy exports. It explains the manufacturing standards when buying antibiotics. If anyone wants factory prices, go here: ?»?kisawyer.us.com. Good info.

  • RichardFek says:

    ?»?Recently, I stumbled upon an interesting article concerning Mexican Pharmacy standards. It details how to save money for ED medication. If you are looking for affordable options, check this out: ?»?web page. Hope it helps.

  • Danielgluct says:

    ?»?Actually, I stumbled upon an interesting page regarding generic pills from India. It details WHO-GMP protocols for ED medication. For those interested in factory prices, read this: ?»?navigate here. Worth a read.

  • Ralphhiere says:

    ?»?Actually, I discovered a useful report regarding cheap Indian generics. The site discusses CDSCO regulations for generic meds. If anyone wants reliable shipping to USA, go here: ?»?reputable indian pharmacies. Cheers.

  • Ralphhiere says:

    ?»?Just now, I found an interesting report about buying affordable antibiotics. It explains the manufacturing standards on prescriptions. If anyone wants Trusted Indian sources, check this out: ?»?indian pharmacy paypal. It helped me.

  • RichardFek says:

    Quick question about getting antibiotics without prescription. I ran into a good post that compares safe places: ?»?polkcity.us.com. Seems useful..

Leave a Reply