Rescue-IP
The fritzbox has a permanent – non changeable – IP-address. With this address you can enter the configuration backend even if you have misconfigured the IP-settings. This IP is:
|
1 |
169.254.1.1 |
Month: April 2012
Flush DNS-Cache
In your terminal you can run the following command under MacOS
|
1 2 3 |
$> sudo dscacheutil -flushcache $> # or $> sudo killall -HUP mDNSResponder |
Copy Database directly to another Database
You can directly copy a database from one host to another host like this:
|
1 |
$> mysqldump -u SOURCE_DB_user --password=SOURCE_DB_pass -h SOURCE_DB_HOST SOURCE_DB_name | mysql -u DB_user --password=DB_pass -h DB_host DB_name |
Import database
|
1 |
$> mysql -h server.host.de -u xxxxxxx -pxxxxxxx database < dump.sql |
or better:
|
1 |
$> gunzip < backup-20120514151839.sql.gz | mysql -u xxxxx -pxxxxx database |
Export database
|
1 |
$> mysqldump -u DB_USER --password=DB_PASSWORD -h DB_HOST DB_NAME > FILENAME.sql |
for compremised:
|
1 |
$> mysqldump -u DB_USER --password=DB_PASSWORD -h DB_HOST DB_NAME | gzip -9 > FILENAME.sql.gz; |
Usefull Params –single-transaction –quick –opt Export all Databases
|
1 |
$> mysqldump -uroot -p -quick --all-databases --skip-lock-tables | gzip -9 > all_dbs.sql.gz; |
