Skip to main content
LinuxMySQLOpen SourceSSHTrucos

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

By 1 October 200713,258 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,258 Comments

  • Ralphhiere says:

    ?»?Recently, I came across an informative report about Indian Pharmacy exports. It covers CDSCO regulations for ED medication. In case you need Trusted Indian sources, read this: ?»?https://kisawyer.us.com/# pharmacy website india. Might be useful.

  • Ralphhiere says:

    ?»?Lately, I discovered a great article concerning generic pills from India. It covers CDSCO regulations when buying antibiotics. If anyone wants Trusted Indian sources, read this: ?»?this link. Might be useful.

  • RichardFek says:

    FYI, an official article on buying meds safely. It breaks down quality control for generics. Link: ?»?https://polkcity.us.com/# pharmacy in mexico that ships to us.

  • RichardFek says:

    FYI, an official analysis on Mexican Pharmacy safety. It explains quality control for ED meds. You can read it here: ?»?https://polkcity.us.com/# order from mexico.

  • Ralphhiere says:

    ?»?Actually, I found an informative article concerning Indian Pharmacy exports. It covers CDSCO regulations on prescriptions. In case you need factory prices, go here: ?»?https://kisawyer.us.com/# online pharmacy india. Worth a read.

  • Ralphhiere says:

    ?»?To be honest, I came across an informative report regarding ordering meds from India. It explains the manufacturing standards on prescriptions. In case you need reliable shipping to USA, read this: ?»?https://kisawyer.us.com/# reputable indian pharmacies. Worth a read.

  • Lloydphics says:

    ?»?Actually, I came across a useful page concerning ordering meds from Mexico. It covers regulations for ED medication. If you are looking for cheaper alternatives, visit this link: ?»?Upstate Medical. Worth a read.

  • Danielgluct says:

    ?»?To be honest, I found a great guide concerning Indian Pharmacy exports. It covers how to save money for generic meds. In case you need Trusted Indian sources, read this: ?»?indianpharmacy com. Hope it helps.

  • Lloydphics says:

    FYI, a detailed overview on cross-border shipping rules. It breaks down quality control for ED meds. Source: ?»?information.

  • RichardFek says:

    Has anybody tried ordering meds from Mexico. I found a cool post that lists affordable options: ?»?resource. What do you think?.

  • Ralphhiere says:

    ?»?Recently, I discovered an informative page about ordering meds from India. It explains CDSCO regulations for generic meds. In case you need cheaper alternatives, check this out: ?»?kisawyer.us.com. Might be useful.

  • Ralphhiere says:

    ?»?Just now, I found an interesting page regarding generic pills from India. It explains the manufacturing standards for generic meds. In case you need reliable shipping to USA, go here: ?»?https://kisawyer.us.com/# ?»?legitimate online pharmacies india. Worth a read.

  • RichardFek says:

    Does anyone know getting antibiotics without prescription. I discovered a decent archive that ranks affordable options: ?»?reading. Seems useful..

  • Danielgluct says:

    ?»?Recently, I found an interesting article concerning generic pills from India. The site discusses the manufacturing standards when buying antibiotics. In case you need cheaper alternatives, take a look: ?»?https://kisawyer.us.com/# reputable indian online pharmacy. Worth a read.

  • RichardFek says:

    ?»?Recently, I discovered a useful resource regarding buying affordable antibiotics. It explains how to save money on prescriptions. In case you need reliable shipping to USA, go here: ?»?mexico pharmacy price list. Hope it helps.

  • Danielgluct says:

    ?»?To be honest, I stumbled upon an interesting report regarding cheap Indian generics. It explains the manufacturing standards for generic meds. If anyone wants Trusted Indian sources, take a look: ?»?read more. Worth a read.

  • Ralphhiere says:

    ?»?Actually, I came across a great report concerning generic pills from India. It covers WHO-GMP protocols on prescriptions. For those interested in factory prices, go here: ?»?https://kisawyer.us.com/# india online pharmacy. Worth a read.

  • Ralphhiere says:

    ?»?Recently, I found a useful guide regarding generic pills from India. It explains the manufacturing standards for generic meds. If you are looking for reliable shipping to USA, check this out: ?»?kisawyer.us.com. Cheers.

  • RichardFek says:

    Has anybody tried safe Mexican pharmacies. I found a cool post that lists trusted vendors: ?»?https://polkcity.us.com/# pharmacy in mexico. Check it out.

  • Danielgluct says:

    ?»?Actually, I discovered a great page concerning ordering meds from India. It covers WHO-GMP protocols for generic meds. In case you need cheaper alternatives, take a look: ?»?buy prescription drugs from india. Cheers.

  • RichardFek says:

    If you want to save big on pills, you should try reading this resource. It shows trusted Mexican pharmacies. Discounted options found here: ?»?https://polkcity.us.com/# mexi pharmacy.

  • Lloydphics says:

    Stop overpaying and save cash on meds, I suggest reading this resource. It shows shipping costs. Discounted options available here: ?»?polkcity.us.com.

  • Lloydphics says:

    Heads up, a helpful guide on buying meds safely. It breaks down the best shipping methods for generics. Full info: ?»?medication from mexico.

  • Danielgluct says:

    ?»?Just now, I came across a helpful page concerning buying affordable antibiotics. The site discusses how to save money for generic meds. If you are looking for Trusted Indian sources, check this out: ?»?here. Hope it helps.

  • Ralphhiere says:

    ?»?Recently, I came across an informative guide regarding generic pills from India. The site discusses how to save money for generic meds. If anyone wants Trusted Indian sources, check this out: ?»?https://kisawyer.us.com/# india online pharmacy. It helped me.

  • Ralphhiere says:

    ?»?Actually, I discovered a helpful resource about Indian Pharmacy exports. The site discusses CDSCO regulations for ED medication. If you are looking for cheaper alternatives, go here: ?»?https://kisawyer.us.com/# buy medicines online in india. Might be useful.

  • RichardFek says:

    If you want to save cash on meds, I suggest checking this page. It reveals where to buy cheap. Good deals at this link: ?»?mexican pharmacies online.

  • RichardFek says:

    Does anyone know buying generic pills online. I saw a cool archive that reviews safe places: ?»?best mexican pharmacy. What do you think?.

  • Danielgluct says:

    ?»?Recently, I found a helpful report about buying affordable antibiotics. The site discusses CDSCO regulations for generic meds. For those interested in Trusted Indian sources, go here: ?»?kisawyer.us.com. Worth a read.

  • Ralphhiere says:

    ?»?Actually, I found a useful article regarding cheap Indian generics. The site discusses how to save money for generic meds. If you are looking for factory prices, read this: ?»?https://kisawyer.us.com/# world pharmacy india. Worth a read.

  • Ralphhiere says:

    ?»?Just now, I stumbled upon a great guide regarding cheap Indian generics. It explains the manufacturing standards for ED medication. If anyone wants Trusted Indian sources, check this out: ?»?indian pharmacies safe. Hope it helps.

  • Danielgluct says:

    ?»?Lately, I came across a helpful page concerning generic pills from India. It explains how to save money on prescriptions. If anyone wants cheaper alternatives, take a look: ?»?this link. It helped me.

  • RichardFek says:

    If you want to save on pharmacy costs, I suggest checking this report. The site explains shipping costs. Huge savings at this link: ?»?Upstate Medical.

  • RichardFek says:

    For those looking to save cash on meds, I suggest reading this page. It reveals trusted Mexican pharmacies. Huge savings found here: ?»?https://polkcity.us.com/# mexican medicine.

  • Danielgluct says:

    ?»?To be honest, I discovered a great article concerning ordering meds from India. The site discusses the manufacturing standards for generic meds. In case you need reliable shipping to USA, check this out: ?»?kisawyer.us.com. Hope it helps.

  • Ralphhiere says:

    ?»?Actually, I found an interesting resource about ordering meds from India. It covers how to save money for ED medication. If you are looking for cheaper alternatives, read this: ?»?https://kisawyer.us.com/# Online medicine home delivery. Might be useful.

  • Ralphhiere says:

    ?»?To be honest, I came across an informative resource about generic pills from India. It covers the manufacturing standards for generic meds. In case you need factory prices, go here: ?»?https://kisawyer.us.com/# online shopping pharmacy india. Worth a read.

  • Lloydphics says:

    Sharing, an official analysis on cross-border shipping rules. It explains pricing differences for antibiotics. Full info: ?»?https://polkcity.us.com/# mexican pharmacies that ship.

  • Danielgluct says:

    ?»?Recently, I discovered a helpful page about cheap Indian generics. It explains CDSCO regulations for generic meds. In case you need factory prices, go here: ?»?https://kisawyer.us.com/# reputable indian pharmacies. Cheers.

  • Lloydphics says:

    ?»?Lately, I came across an interesting report regarding safe pharmacy shipping. The site discusses regulations on prescriptions. For those interested in affordable options, read this: ?»?Upstate Medical. It helped me.

  • Danielgluct says:

    ?»?Lately, I came across an informative report about cheap Indian generics. It details WHO-GMP protocols on prescriptions. In case you need Trusted Indian sources, take a look: ?»?https://kisawyer.us.com/# top 10 pharmacies in india. Worth a read.

  • Ralphhiere says:

    ?»?Actually, I found a helpful page about cheap Indian generics. It details how to save money when buying antibiotics. If you are looking for reliable shipping to USA, read this: ?»?read more. Cheers.

  • Danielgluct says:

    ?»?Lately, I came across a helpful report about buying affordable antibiotics. The site discusses the manufacturing standards for ED medication. If you are looking for factory prices, visit this link: ?»?https://kisawyer.us.com/# buy prescription drugs from india. Good info.

  • Danielgluct says:

    ?»?Actually, I came across a helpful report regarding Indian Pharmacy exports. It covers WHO-GMP protocols when buying antibiotics. If anyone wants reliable shipping to USA, take a look: ?»?indianpharmacy com. Good info.

  • RichardFek says:

    ?»?Lately, I stumbled upon a helpful guide concerning buying affordable antibiotics. It details the safety protocols for generic meds. In case you need affordable options, take a look: ?»?https://polkcity.us.com/# pharmacys in mexico. Hope it helps.

  • RichardFek says:

    Heads up, a detailed article on FDA equivalent standards. It explains how to avoid scams for antibiotics. You can read it here: ?»?https://polkcity.us.com/# los algodones pharmacy online.

  • Ralphhiere says:

    ?»?To be honest, I found an informative page concerning Indian Pharmacy exports. It explains how to save money when buying antibiotics. If anyone wants reliable shipping to USA, go here: ?»?https://kisawyer.us.com/# india pharmacy mail order. Cheers.

  • Danielgluct says:

    ?»?Recently, I found a useful guide regarding buying affordable antibiotics. It covers WHO-GMP protocols when buying antibiotics. If anyone wants reliable shipping to USA, go here: ?»?kisawyer.us.com. Hope it helps.

  • Ralphhiere says:

    ?»?Lately, I came across an informative article concerning ordering meds from India. It details the manufacturing standards when buying antibiotics. If you are looking for reliable shipping to USA, take a look: ?»?best online pharmacy india. Good info.

  • Lloydphics says:

    Quick question about getting antibiotics without prescription. I found a cool post that ranks safe places: ?»?https://polkcity.us.com/# mexico online farmacia. Any thoughts?.

Leave a Reply