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
To compromise (gzip) the output: Usefull Params –single-transaction –quick –opt Export all Databases Through an ssh tunnel