Category: mysql

Database too large for phpMyAdmin upload

In ‘/etc/phpmyadmin/’ 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:

Moving a MySQL database

You just need a couple commands… then… This explains how to do it… 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;"