• home
• Contact
• Dashboard
• IP Address
• TVS
• LinkedIn
• GitHub
• prohlížet ↓

Rubrika

Databáze

• 2013.07.15
  MySql export/import schema without data Databáze | (0)

  Shell

  for x in db1 db2 db3;do echo $x && mysqldump -uroot -p"password" --no-data $x > /tmp/schema_$x.sql; done for x in db1 db2 db3;do echo $x && mysql -uroot -p"password" $x < /tmp/schema_$x.sql; done

  1 2	for x in db1 db2 db3;do echo $x && mysqldump -uroot -p"password" --no-data $x > /tmp/schema_$x.sql; done for x in db1 db2 db3;do echo $x && mysql -uroot -p"password" $x < /tmp/schema_$x.sql; done

• 2011.02.01
  Adminer is better than phpMyAdmin Databáze | (0)

  „Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. It is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.“

  I agree!

  – very fast GUI
  – just one php file
  – upload and run
  – more than one sql query

  source:
  http://www.adminer.org/en/phpmyadmin/
  http://sourceforge.net/projects/adminer/