mysql

Copy a MySQL Database to a new Server via ssh with one command

by eltupper
May 4, 2013

mysqldump –add-drop-table –extended-insert –force –log-error=error.log -uUSER -pPASS OLD_DB_NAME | ssh -C user@newhost “mysql -uUSER -pPASS NEW_DB_NAME”

Mostrar todas las tablas de una base de datos

by NicholasPhillips
April 28, 2013

<?php $dbhost = “servidor”; $dbuser = “usuario”; $dbpassword = “clave”; $dbname = “base_de_datos”; mysql_connect($dbhost,$dbuser,$dbpassword); $tablas = mysql_list_tables($dbname); while (list($tabla) = mysql_fetch_row($tablas)) { echo $tabla.“<br />”;… Read More »Mostrar todas las tablas de una base de datos

« Previous
1
2
3