Category: mysql

Database too large for phpMyAdmin upload

In ‘/etc/phpmyadmin/config.inc.php’ change this line $cfg['UploadDir'] = '/etc/phpmyadmin/upload' Make a folder named upload in that location. Now in phpMyAdmin, you can pick files from that directory for upload. (found here:http://daipratt.co.uk/importing-large-files-into-mysql-with-phpmyadmin/)

Moving a MySQL database

You just need a couple commands… then… This explains how to do it… http://www.clockwatchers.com/mysql_dump.html Enjoy

MySQL on Linux

MySQL is foreign to me, and this is really basic stuff, but here it is: I figured out how to access mysql on linux… mysql -h localhost -u username -p … it then prompts for the password. From there you "use collection_name;" to choose the collection_name databases, "show databases;" will…well…duh! "show tables;"