Skip to main content

Importing a large database

If you're trying to import a large database into your local database, there's really a simple solution.

On Windows, if you're running WAMP Server, click on the WAMPSERVER icon in your task-bar. Under the MySQL folder, select my.ini. In the text file, you'll see a myisam_sort_buffer_size. Change it to something large (i.e. 1000M). Save the file and restart all services (click the WAMPSERVER icon and click Restart All Services).

Next, open CMD. Navigate to your mysql folder in the wamp directory. For me it was:
C:\wamp\bin\mysql\mysql.5.17\bin

In the bin folder, there will be a utility called mysql that we'll use in a second.

To simplify the next step, once you've exported the .sql database, move the file from your Downloads Folder to the same bin folder specified above (note that your path may be different than mine).

Once the file is in the folder, i.e. test.sql, make sure that on your local server you have a database created with the same name as the one you exported. In this example the database name will be TestDB.

Since you probably didn't delete the root user from your local install, just use root as the username in the next step.

In CMD, type in:
C:\wamp\bin\mysql\mysql.5.17\bin>mysql -u root -p TestDB < test.sql

After you hit enter, it'll prompt you to enter a password. Since your root password is most likely blank, hit Enter. Once the process finishes the import, you'll be able to type something else into CMD. At that point, check your database via phpMyAdmin and you'll notice that everything has been imported.

Comments

Post a Comment

Popular posts from this blog

Beginner Java Exercise: Sentinel Values and Do-While Loops

In my previous post on while loops, we used a loop-continuation-condition to test the arguments. In this example, we'll loop at a sentinel-controlled loop. The sentinel value is a special input value that tests the condition within the while loop. To jump right to it, we'll test if an int variable is not equal to 0. The data != 0 within the while (data != 0) { ... } is the sentinel-controlled-condition. In the following example, we'll keep adding an integer to itself until the user enters 0. Once the user enters 0, the loop will break and the user will be displayed with the sum of all of the integers that he/she has entered. As you can see from the code above, the code is somewhat redundant. It asks the user to enter an integer twice: Once before the loop begins, and an x amount of times within the loop (until the user enters 0). A better approach would be through a do-while loop. In a do-while loop, you "do" something "while" the condition
13 comments
Read more

Programming Language Concepts Test Questions/Answers

One of the easiest methods that I use to learn new topics is by creating notes on the subject and then by turning those notes into questions and answers. Remembering answers to questions just seems more natural. I was able to memorize 323 questions and answers in a matter of a couple of days. I wanted to start doing this for some topics that I find pretty interesting. To begin, here are some questions and answers to Programming Language Concepts (PLC). I'm reading your mind right now and the answer is yes, there will be more. 1. Name 3 reasons for studying PLC. - Better understanding of current programming languages - Advancement of computing - Increased capability to express ideas - Increased capability to learn new programming language. - Better understanding of which programming language to choose.  2. Name the 5 programming domains and languages best suited for each. - Scientific (Fortran, ALGOL 60) - Business (COBOL) - AI (Lisp, Scheme, Prolog) - Web (PHP,
12 comments
Read more

Creating your own ArrayList in Java

Wanted to show that certain data structures in Java can be created by you. In this example, we'll go ahead and create an ArrayList data structure that has some of the methods that the built in ArrayList class has. We'll create 2 constructors: The default constructor that creates an ArrayList with a default size of 10. Constructor that allows an initial size to be passed to the array. We'll also create a number of methods: void add(Object x);  A method that allows you to place an Object at the end of the ArrayList. void add(int index, Object x);  A method that allows you to place a value at a given location. Object get(int index):  Allows you to retrieve a value of the arrayList array from a given location. int size();  Allows you to get the number of elements currently in the Arraylist. boolean isEmpty();  Tests to see if the Arraylist is empty. boolean isIn(Object x);  A method that sees if a particular object exist in the arrayList. int find(Object x);  
48 comments
Read more