Restoring entire SQL Database from file

One night I had to restore my entire SQL database server from a SQL file, but it took me a while to find how to restore this file without restoring specific databases.

Below are the commands for Linux.

If you have shell (command-line) access, use MySQL to import the files directly. You can do this by issuing the "source" command:
$su -
Password:
# mysql -u -p source
Once you have entered the password to your MySQL username, the restoration process will soon begin.

Comments

Post a Comment

Popular posts from this blog

Repair Windows 7 after removing a Linux partition (Dual Boot)

Image
I have seen the appear alot in the forums of people are running a dual boot scenario on their computers, dual-booting Windows with Linux, and no longer want the Linux system. Simply removing the paritions causes Windows to longer boot. In this article I explain how you can fix this problem. In this article, I will show you how to repair Windows 7 after removing Ubuntu 11.10. Although, this will work regardless of the distribution of Linux you are using. When you remove the Linux partition(s) you essentially remove the boot loader and screw up the master boot record. This need to be repaired for Windows to work again. Contents Removing the Linux Partitions Repairing Windows Boot Loader Removing the Linux Partitions Boot to Windows 7 and open Computer Management. Do this by either right-clicking My Computer and selecting Manage, or simple search for Computer Management from the Start Menu. Once open, select Disk Management. Here you will see the layout of the
Read more

Office 365 ScanPST to fix corrupted Outlook files

Image
In Office 365, which uses the Click-to-Run technology, Office program files are now in a new location. When you experience issues with Outlook, often you would use the ScanPST.exe tool to repair PST and OST files with Outlook. This tool can now be found in the following location: C:\Program Files\Microsoft Office 15\root\office15\ScanPST.exe This should apply for both 32-bit and 64-bit installations of Office 365. Update: Microsoft has published a Knowledge Base article list the locations of the ScanPST utility depending on your installation of Office 365. Whether you're using 32 or 64 bit versions. https://support.microsoft.com/en-us/kb/272227
Read more

HP LaserJet P3005 Cold Reset

Image
To perform a factory / hard / cold reset on a HP LaserJet P3000 Series printer wasn't that straight forward in my eyes. Although in the menus there was an option for Reset Factory Defaults, this did very little in erasing the configuration and returning the printer to a default state. After reading through a few manuals I found the following performed what HP call a Cold Reset. Cold reset A cold reset unlocks menus that have been previously locked and sets all control panel menu items(including EIO settings) back to the factory defaults. However, it does not clear the values in the SERVICE menu (such as the serial number and page counts). NOTE    Before performing a cold reset, print a menu map and a configuration page. Use the information on the configuration page to reset any customer-set device configuration values that the cold reset procedure changes. Turn the device off. Turn the device on. When the memory count begins, press and hold the green Check butto
Read more