If you need to move your MySQL database from one server to another, you can use the following codes.

Dump:

mysqldump -u root -pPASSWORD DatabaseName > dbbackup.sql

Import:

mysql -u root -pPASSWORD DatabaseName < dbbackup.sql

You can do this process live.

There is no quick way to drop all tables of a MySQL database. You can just drop the database instead. But if you just want to drop all tables, you can use following codes.

mysql -u root -pPASSWORD DatabaseName -e "show tables" | grep -v Tables_in | grep -v "+" | \gawk '{print "drop table " $1 ";"}' | mysql -u root -pPASSWORD DatabaseName

I found the code from another website but it was for password-less MySQL servers. I added password authentication.

If you want to see arp table of Fortigate,

1. Login to Fortigate via SSH.

2. Go into VDOM (if you have)

config VDOM
edit CustomerVDOM01

3. Use the following command to see arp table.

get system arp

Have fun!

You may get this error when you try to access MySQL server on Windows.

Solution:

1. Stop MySQL service (from services.msc)

2. Create a text file in C:\ called “init.txt”. Paste the following code and save it.

GRANT ALL PRIVILEGES ON mysql.* TO root@localhost IDENTIFIED BY 'YourPassword!' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON mysql.* TO root@127.0.0.1 IDENTIFIED BY 'YourPassword!' WITH GRANT OPTION;

3. Open command prompt (cmd)

4. Go to MySQL bin directory on cmd.

Example: C:\Program Files\MySQL\MySQL Server 5.1\bin

You can use WebPI 3.0 for installing PHP 5.3 and MySQL on Windows Server 8.

1. You can choose PHP 5.3.8 and URL Rewrite from WebPI.

2. Installation completed without problem.

3. I also choose MySQL for database support.

4. Installation completed without problem.

WebPI doesn’t work to install IIS on Windows 8 but you can still install PHP and MySQL component with it.

I’ll show you how to install IIS8 recommended configuration on Windows Server 8.

1. Go to Server Manager, click “Manage” and click “Add Roles and Features”.

2. Select “Role-based or Feature-based installation”

3. Choose your server or server pool.

4. Choose “Web Server (IIS)”.

5. Click to frameworks if they are not installed.

6. Skip IIS8 introduction.

7. Choose same features with me (Part 1)

8. Choose same features with me (Part 2)

9. Choose same features with me (Part 3)

10. Choose same features with me (Part 5)

11. Click install to start installation.

12. You can see clean installation progress.

13. IIS8 UI has no big changes.

Now, you can start to create your websites.

Merhaba,

Aşağıda Parallels Plesk Panel 10 sürüm ve komponent bilgilerini bulabilirsiniz.

parallels_installer.exe --show-all-releases

Release id için “PANEL_10_2_0_WIN” kullanmalısınız.

parallels_installer.exe --select-release-id PANEL_10_2_0_WIN --show-components

Ayrıca Parallels Small Business Panel’in komponentlerine bakalım:

parallels_installer.exe --select-release-id PPSMBE_10_0_0_WIN --show-components

“parallels_installer.exe” dosyasını Parallels’in web sayfasından indirebilirsiniz.