Mirroring MySQL databases with mysqldump
We will use mysqldump to synchronize your mirror and production server databases. Before running mysqldump, you will need to create a MySQL user on your mirror server, and you will need to create empty databases with the same names as the databases on your production server.
Once you have setup your mirror server databases, log into your mirror via ssh, and run the following command to sync a database:
mysqldump -h productionIP -u productionMySQLuser -pproductionPassword productionDBname | mysql -h mirrorIP -u mirrorMySQLuser -pmirrorPassword mirrorDBname
productionIP – the IP address of your production server
productionMySQLuser – the MySQL user on your production server
productionPassword – the password for your MySQL user on your production server (be sure to type your password immediately after typing the “-p” — no spaces)
productionDBname – name of the production server database that you want to backup
mirrorIP – the IP address of your mirror server
mirrorMySQLuser – the MySQL user on your mirror server (you will need to create this user via your mirror CPanel)
mirrorPassword – the password for the MySQL user on your mirror server
mirrorDBname – the database you are backing up to on your mirror server (this database will need to be named the same as the database on your production server, and you will need to create this database before running mysqldump)
Selasa, 27 Maret 2012
Rabu, 14 Maret 2012
grant mysql
grant all on *.* to `root`@`%` identified by 'pegadaian' with grant option;
grant all on *.* to `root`@`%` identified by 'pegadaian' with grant option;
flush privileges;
grant all on *.* to `root`@`%` identified by 'pegadaian' with grant option;
flush privileges;
Minggu, 11 Maret 2012
Connection to database failed.
Connection to database failed.
dbExpress Error: Invalid
Username/Password
cara membetulkannya
mysql -u root -p
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('r00tp45sw0rd');
UPDATE mysql.user SET Password = OLD_PASSWORD('r00tp45sw0rd') WHERE Host = 'localhost' AND User = 'root';
FLUSH PRIVILEGES;
dbExpress Error: Invalid
Username/Password
cara membetulkannya
mysql -u root -p
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('r00tp45sw0rd');
UPDATE mysql.user SET Password = OLD_PASSWORD('r00tp45sw0rd') WHERE Host = 'localhost' AND User = 'root';
FLUSH PRIVILEGES;
Selasa, 07 Februari 2012
redirect spring
return "redirect:/utama.htm";
untuk request parameter
@RequestParam("link") String link,
untuk request parameter
@RequestParam("link") String link,
Minggu, 01 Januari 2012
JMeter Multiple User
You can use a CSV Data Set Config. This control will allow you to use an external source of variables. Add -> Config Element -> CSV Data Set Config You must set the variable names, something like: Variable Names (comma-delimited): USERNAME,PASSWORD
Then you can use the variables in your HTTP Requests parameters like: ${USERNAME} and ${PASSWORD}
Then you can use the variables in your HTTP Requests parameters like: ${USERNAME} and ${PASSWORD}
Minggu, 27 November 2011
get IP Address
public void service(HttpServletRequest req, HttpServletResponse res)
throws IOException {
String IP = req.getRemoteAddr();
}
throws IOException {
String IP = req.getRemoteAddr();
}
Selasa, 22 November 2011
Akses USB Virtualbox Ose ubuntu
untuk dapat mengakses USB pada virtualbox ose yaitu dengan
Add yourself to the user group vboxusers, then log out and back in, to make use of available USB devices. To do this via the graphical interface, click System Settings/Users and Groups/Manage Groups.
https://help.ubuntu.com/community/VirtualBox/USB
Add yourself to the user group vboxusers, then log out and back in, to make use of available USB devices. To do this via the graphical interface, click System Settings/Users and Groups/Manage Groups.
https://help.ubuntu.com/community/VirtualBox/USB

Langganan:
Postingan (Atom)