MySQL using Command Line on PC with XAMPP installed

By -
With XAMPP when you have to import a very big mysql table, even though you have increase the script time in php.ini but sometimes it still does not cut the mustard. I found out another way to do this by going through the command line interface. For this example, I am going to use ms-dos in Microsoft Windows, however you can do similar thing with SSH.

  1. Navigate to your MySQL folder (by default it should be C:\xampp\mysql\bin)
  2. Run mysql.exe with this command: mysql -u yourusername -p yourpassword.
  3. Once you are in MySQL interface, then type use dataBaseName. If the dataBase is not set yet, run this command: create database databaseName;
  4. After the new database created, type use databaseName;
  5. To import, type: source pathToSQLData. In PC, it will be something like source C:\xampp\htdocs\backup.sql
  6. It should start importing your data now.

Extra tip: In the command line, you can do all sort of other things that you usually type in phpmyadmin sql section, it will be just faster and not constrained by time limit you have in php.ini.

Comments

Post a Comment

Popular posts from this blog

Hiren can not load the CD ROM Driver

By -
Image
Hiren Boot CD is a superb all in one tools, that helps from regular user to the IT tech guys alot. If you boot this CD, you will find heaps of tools such as: mini windows XP, recovery, backup, partition, and other tools. But the problem is, if your optical drive is using SATA connection, sometimes Hiren's bootCD will required drive emulation as it only support ATA optical drive. The result: it won't be able to loads it's driver. So one way to solve the computer with SATA optical drive is by using Hiren in USB instead. In this post, I'll show you step by step on how I did it (credit goes to hiren.info for the information). Connect a USB Drive (256Mb or more). Right click the USB drive in Windows Explorer, and choose format (this step will destroy all the data inside the USB stick, so make sure you already have backup the data you need). You can tick quick format if you are sure the USB stick is still in a good condition, or just untick it if you afraid you have badsector
Read more

Enable PHP opcache extension on Windows XAMPP

By -
If your XAMPP comes with PHP 5.5+ by default, opcache already included in the bundle, you will just need to enable it. To enable the extension: Open php.ini (by default it should be located here: C:\xampp\php\php.ini). Add this line at the end of the file: zend_extension = "C:\xampp\php\ext\php_opcache.dll" You will need to adjust the path if you installed XAMPP in non default location. Restart Apache server.
Read more

Sunrose USB Fingerprint Reader Driver

By -
Image
Also known as the ELAN Smart-id Fingerprint. Steps to resolve: Download the driver  (Tested on Windows 10) Extract the Zip file Go to device management, find ELAN Fingerprint, right-click and select update driver Locate the driver inside the extracted files Let me know in the comment below if you still have any issue(s)
Read more