Skip to main content

Importing Mysql file using Source Command

1. Create an empty database in phpMyadmin. Main thing to do is give it the same name as the sql file you are trying to upload. One can also use command CREATE DATABASE databasename;

2. Log on into shell: mysql -u root -p. It will then ask you for your root password. Type it in

3. Let Mysql know which file you intend to use

mysql> USE file.sql;. (If you fail to use the USE command you can end up with this error: “error 1046 (3D0000): no database selected. If your database is large this error can freeze the screen)

4. Dump the sql data file with this code: SOURCE /home/username/foldername/file.sql.

AND U R DONE.

Comments

Popular posts from this blog

XAMPP: Couldn't start MySQL!

XAMPP: Couldn't start MySQL! Trying to run mysql on ubuntu 10.10 and give this vauge error "XAMPP: Couldn't start MySQL!" Try this 1. Open a terminal. 2. run this command sudo chown -hR root /opt/lampp 3. then run this sudo chmod -R 777 /opt/lampp 4. Now Restart XAMPP sudo /opt/lampp/lampp restart U are all set. And if u r getting the follwing warning after restarting "Warning: World-writable config file ‘/opt/lampp/etc/my.cnf’ is ignored" 1.Open terminal 2.Migrate to /opt/lampp/etc 3.run the command sudo chmod 755 my.cnf

Show full path in iterm

Show Full Path in Terminal Opern Iterm, duh! Go to you home direct Type:   cd ~ Type:   mate .bashrc Type:  export PS1=" " Between the quotation marks, you can add the following lines to customize your Terminal prompt: \d – Current date \t – Current time \h – Host name \# – Command number \u – User name \W – Current working directory (ie: Desktop/) \w – Current working directory, full path (ie: /Users/Admin/Desktop) export PS1="\u@\h\w$ "   which will look like:  Admin@MacBook~Desktop/$ " mate is text mate you need to install it in mac to make it work or you can also use free editors like nano, vi/vim. Source: soniajahid