Most people know on how to install windows server using VMWare Workstation. But not all know on how to configure the “Shared Storage” to store Quorum drive (Q:\) and Data (S:\) when they try setting up Windows Clustering. Following are the step, it’s may help. I’ve done it!
1) Create a new guest virtual machine with the following settings or higher:
RAM: 256MB
HDD0: SCSI, 4 GB
CDROM
Ethernet 1: Bridged
Ethernet 2: Host-only
In a computer, My Documents folder is very important, which you can store your documents, graphics, and other personal files.
By default, the target or actual location of My Documents folder is C:\Documents and Settings\username\My Documents, where C:\ is the drive in which Windows is installed, and username is the currently logged-on user.
It’s more benefit if you change the default location of My Documents on your machine. Below are the reason why we need to change the default location of My Documents:
Use the following step to change the default location of the My Documents folder:
1. Click Start, and then point to My Documents.
2. Right-click My Documents, and then click Properties. Go to Target tab.
3. Click on the “Move” button and browse to a location on your other partition/ hard disk.
4. If you not create yet the folder, you can use “Make New Folder” button to create it.
5. Click OK. Windows will ask if you want to move the current files in your “old” My Documents folder to the new location. Select “Yes”.
6. You might get additional dialogs about moving read-only files or system files.
Use the following step to restore the My Documents folder to its default location,
1. Click Start, and then point to My Documents.
2. Right-click My Documents, and then click Properties.
3. Click Restore Default, and then click OK.
4. In the Move Documents box, click “Yes” to move your documents to the new location, or click “No” to leave your documents in the original location.
That’s all. I’ve done it!
This method apply to XAMPP and phpMyAdmin.
1. Backup database from the source. Normally the database will using name : localhost.sql
2. After backup, transfer to any folder in the MySQL server that you want to restore, it’s better put into /root
3. Delete database using phpMyadmin if the database exist
3. Then execute commmand: mysql -u root -p < localhost.sql
4. If using XAMPP, it may show error message: -bash: -bash:: command not found
5. If you found this error, try find using this command: find /opt/lampp -name mysql
6. You should found this result: /opt/lampp/bin/mysql
7. Now create shortcut to execution path (/bin)
8. Using this command to create shortcut: ln -s /opt/lampp/bin/mysql /bin/mysql
9. After that, try again to execute: mysql -u root -p < localhost.sql
10. If everything OK, you should prompted the phpMyadmin password
11. Enter password and it will restore the database
12. Double check again the restored database
Good Luck!
Are you found similar error below?
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 2411535 bytes)in /opt/lampp/phpmyadmin/libraries/import.lib.php on line 269
This message appear when you try to restore the MySQL database using phpMyAdmin restore wizard.
Solutions:
1. Create file info.php at htdocs
2. Add below code into info.php:
<?
phpinfo();
?>
3. Load the info.php at your browser
4. Find the parameter –> Loaded Configuration File
Verify the value : it should be : /opt/lampp/etc/php.ini
5. Then, go the the location of php.ini. Open it
6. Then find parameter -> memory_limit. View the memory (Normally default size is 8M)
7. Change it to 256M and save it (It’s depend on your total memory.If you can assign more is better)
8. Restart XAMPP/Apache
9. Load again info.php
10. Check memory_limit. It should changed to 256M
11. You’re done. Try to restore again the database.
That’s all!
