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

  • Danielgluct says:

    ?»?Lately, I discovered a useful article regarding Indian Pharmacy exports. It explains the manufacturing standards for generic meds. If you are looking for cheaper alternatives, visit this link: ?»?india pharmacy mail order. Good info.

  • RichardFek says:

    ?»?Just now, I came across a great report concerning Mexican Pharmacy standards. It details the safety protocols for generic meds. If you are looking for cheaper alternatives, take a look: ?»?https://polkcity.us.com/# buying prescriptions in mexico. Good info.

  • Ralphhiere says:

    ?»?Recently, I stumbled upon a useful page about ordering meds from India. The site discusses CDSCO regulations for generic meds. In case you need factory prices, visit this link: ?»?kisawyer.us.com. Hope it helps.

  • Ralphhiere says:

    ?»?To be honest, I discovered a helpful article concerning Indian Pharmacy exports. It explains WHO-GMP protocols when buying antibiotics. For those interested in cheaper alternatives, take a look: ?»?https://kisawyer.us.com/# online shopping pharmacy india. Cheers.

  • RichardFek says:

    Does anyone know safe Mexican pharmacies. I ran into a verified blog that ranks safe places: ?»?polkcity.us.com. Looks legit.

  • Danielgluct says:

    ?»?To be honest, I found an interesting report regarding Indian Pharmacy exports. It details how to save money on prescriptions. In case you need factory prices, visit this link: ?»??»?click here. Hope it helps.

  • Lloydphics says:

    Stop overpaying and save big on pills, you should try visiting this resource. It reveals shipping costs. Good deals found here: ?»?useful link.

  • RichardFek says:

    Sharing, an important analysis on Mexican Pharmacy safety. It explains the best shipping methods for ED meds. Link: ?»?link.

  • Lloydphics says:

    For those looking to save on pharmacy costs, I suggest visiting this report. It shows trusted Mexican pharmacies. Best prices at this link: ?»?hydrocodone mexico pharmacy.

  • Danielgluct says:

    ?»?Just now, I discovered a great resource regarding Indian Pharmacy exports. It explains the manufacturing standards on prescriptions. In case you need factory prices, take a look: ?»?go. Worth a read.

  • Ralphhiere says:

    ?»?Just now, I discovered a great guide about cheap Indian generics. It covers the manufacturing standards for generic meds. For those interested in cheaper alternatives, visit this link: ?»?https://kisawyer.us.com/# online pharmacy india. Worth a read.

  • Ralphhiere says:

    ?»?Just now, I stumbled upon a useful guide regarding cheap Indian generics. It covers how to save money for ED medication. If you are looking for reliable shipping to USA, read this: ?»?https://kisawyer.us.com/# indian pharmacy paypal. Good info.

  • RichardFek says:

    I was wondering about buying generic pills online. I ran into a cool post that ranks best pharmacies: ?»?see more. Looks legit.

  • Danielgluct says:

    ?»?Recently, I stumbled upon an informative page about Indian Pharmacy exports. It covers the manufacturing standards on prescriptions. For those interested in Trusted Indian sources, visit this link: ?»?check it out. Hope it helps.

  • RichardFek says:

    Has anybody tried getting antibiotics without prescription. I ran into a good blog that ranks best pharmacies: ?»?https://polkcity.us.com/# mexican pharmacy prices. Seems useful..

  • Danielgluct says:

    ?»?Lately, I discovered a great report about buying affordable antibiotics. It details the manufacturing standards on prescriptions. If anyone wants reliable shipping to USA, visit this link: ?»?useful link. Good info.

  • RichardFek says:

    I was wondering about safe Mexican pharmacies. I saw a verified blog that reviews affordable options: ?»?https://polkcity.us.com/# mexican pharmacy las vegas. Seems useful..

  • Danielgluct says:

    ?»?Recently, I found a great report regarding ordering meds from India. It details how to save money for generic meds. If anyone wants cheaper alternatives, visit this link: ?»?top online pharmacy india. Hope it helps.

  • RichardFek says:

    Sharing, a helpful overview on cross-border shipping rules. It breaks down how to avoid scams for antibiotics. Link: ?»?check it out.

  • Danielgluct says:

    ?»?Actually, I found a helpful page concerning ordering meds from India. It explains WHO-GMP protocols on prescriptions. For those interested in cheaper alternatives, go here: ?»?https://kisawyer.us.com/# top 10 pharmacies in india. Hope it helps.

  • Lloydphics says:

    Just wanted to share, an important article on FDA equivalent standards. The author describes the best shipping methods for ED meds. Source: ?»?Upstate Medical.

  • Ralphhiere says:

    ?»?To be honest, I came across a helpful report regarding ordering meds from India. It explains CDSCO regulations for ED medication. For those interested in factory prices, go here: ?»?https://kisawyer.us.com/# india online pharmacy. Might be useful.

  • Lloydphics says:

    If you want to save on pharmacy costs, I suggest checking this report. The site explains trusted Mexican pharmacies. Best prices available here: ?»?https://polkcity.us.com/# mexican pharmacy prices.

  • Danielgluct says:

    ?»?Lately, I found an interesting article regarding generic pills from India. It covers how to save money on prescriptions. For those interested in cheaper alternatives, check this out: ?»?see more. Good info.

  • RichardFek says:

    For those looking to save on pharmacy costs, I suggest visiting this report. It shows shipping costs. Good deals found here: ?»?polkcity.us.com.

  • RichardFek says:

    Quick question about ordering meds from Mexico. I found a cool archive that ranks best pharmacies: ?»?mexico farmacia. Looks legit.

  • Danielgluct says:

    ?»?To be honest, I came across a helpful guide concerning generic pills from India. It details CDSCO regulations for generic meds. If anyone wants factory prices, take a look: ?»?resource. Hope it helps.

  • Ralphhiere says:

    ?»?Lately, I stumbled upon an interesting report concerning buying affordable antibiotics. It explains the manufacturing standards on prescriptions. If anyone wants cheaper alternatives, check this out: ?»?click to read. Worth a read.

  • Ralphhiere says:

    ?»?Just now, I discovered a helpful page regarding generic pills from India. It details the manufacturing standards on prescriptions. If you are looking for cheaper alternatives, take a look: ?»?cheapest online pharmacy india. It helped me.

  • RichardFek says:

    Has anybody tried buying generic pills online. I saw a verified site that ranks trusted vendors: ?»?https://polkcity.us.com/# medication in mexico. Check it out.

  • Ralphhiere says:

    ?»?To be honest, I found a useful report concerning Indian Pharmacy exports. It details CDSCO regulations for generic meds. For those interested in factory prices, take a look: ?»?https://kisawyer.us.com/# buy medicines online in india. Might be useful.

  • Ralphhiere says:

    ?»?Lately, I discovered an interesting guide regarding buying affordable antibiotics. The site discusses CDSCO regulations for ED medication. In case you need cheaper alternatives, check this out: ?»?https://kisawyer.us.com/# india online pharmacy. It helped me.

  • Danielgluct says:

    ?»?Actually, I stumbled upon a useful page about Indian Pharmacy exports. It explains the manufacturing standards for generic meds. If anyone wants cheaper alternatives, visit this link: ?»?https://kisawyer.us.com/# top online pharmacy india. Might be useful.

  • RichardFek says:

    ?»?To be honest, I found a helpful page about safe pharmacy shipping. It explains how to save money when buying antibiotics. In case you need cheaper alternatives, check this out: ?»?Upstate Medical. Worth a read.

  • Lloydphics says:

    Stop overpaying and save big on pills, I suggest visiting this archive. The site explains shipping costs. Best prices found here: ?»?Upstate Medical.

  • RichardFek says:

    To save on pharmacy costs, I suggest checking this resource. It shows where to buy cheap. Discounted options at this link: ?»?polkcity.us.com.

  • Lloydphics says:

    I was wondering about buying generic pills online. I ran into a good archive that compares trusted vendors: ?»?https://polkcity.us.com/# mexico pharmacy price list. Seems useful..

  • Danielgluct says:

    ?»?Lately, I came across an informative resource about generic pills from India. It explains WHO-GMP protocols for ED medication. If you are looking for reliable shipping to USA, visit this link: ?»?click to read. Hope it helps.

  • Ralphhiere says:

    ?»?Actually, I came across an interesting article about buying affordable antibiotics. It covers the manufacturing standards for ED medication. If anyone wants factory prices, read this: ?»?kisawyer.us.com. Good info.

  • Ralphhiere says:

    ?»?Actually, I discovered a great resource concerning ordering meds from India. It covers how to save money for generic meds. For those interested in factory prices, visit this link: ?»?visit. Hope it helps.

  • Danielgluct says:

    ?»?Just now, I found an informative resource concerning cheap Indian generics. It details WHO-GMP protocols for ED medication. If anyone wants Trusted Indian sources, visit this link: ?»?homepage. Might be useful.

  • RichardFek says:

    I was wondering about buying generic pills online. I saw a good post that reviews trusted vendors: ?»?https://polkcity.us.com/# mexican rx. Any thoughts?.

  • RichardFek says:

    Stop overpaying and save cash on meds, I suggest visiting this page. It reveals where to buy cheap. Discounted options found here: ?»?Upstate Medical.

  • Danielgluct says:

    ?»?Recently, I found an interesting report regarding Indian Pharmacy exports. The site discusses WHO-GMP protocols for generic meds. For those interested in cheaper alternatives, take a look: ?»?https://kisawyer.us.com/# india pharmacy mail order. Hope it helps.

  • Ralphhiere says:

    ?»?Recently, I discovered a useful page concerning Indian Pharmacy exports. It explains WHO-GMP protocols for generic meds. If anyone wants reliable shipping to USA, check this out: ?»?link. Good info.

  • Ralphhiere says:

    ?»?Recently, I stumbled upon a useful guide regarding ordering meds from India. It details CDSCO regulations on prescriptions. For those interested in reliable shipping to USA, take a look: ?»?mail order pharmacy india. Worth a read.

  • Danielgluct says:

    ?»?Actually, I found a great page about buying affordable antibiotics. The site discusses CDSCO regulations for ED medication. In case you need Trusted Indian sources, check this out: ?»?https://kisawyer.us.com/# best india pharmacy. Might be useful.

  • RichardFek says:

    FYI, a helpful article on cross-border shipping rules. It explains pricing differences for generics. Source: ?»?polkcity.us.com.

  • RichardFek says:

    I was wondering about ordering meds from Mexico. I found a decent archive that compares best pharmacies: ?»?polkcity.us.com. Looks legit.

  • Danielgluct says:

    ?»?Actually, I found an interesting report concerning Indian Pharmacy exports. The site discusses WHO-GMP protocols for generic meds. If anyone wants factory prices, read this: ?»?this link. It helped me.

Leave a Reply