Posts Tagged ‘mysql’

I wanted to import a big sql file to a remote Mysql Host. The phpmyadmin wasn’t very friendly because the max upload file size supported was 15mb. So i used the following

mysql -h remote.mysql.host.or.ip -u YOURUSERNAME -p YOURDATABASENAME < YOUR_FILE.SQL

I installed mytop in my debian system. Mytop is  is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL server.
I got this error message when i run it

Error in option spec: "long|!"

to fix it i edit

vim /usr/local/bin/mytop

find

"long|!"              =&gt; \$config{long_nums},

and comment it out with #

or just install the new 1.7 version from here
https://github.com/jzawodn/mytop