Tagged Questions
1
vote
3answers
184 views
Error dropping database in MySQL 5.1 on Ubuntu
I am using MySQL v5.1 on Ubuntu machine.
I have a database named my_db which I would like to drop it, so I execute command:
mysql> drop database my_db;
ERROR 1010 (HY000): Error dropping ...
0
votes
4answers
146 views
Restart MySQL server
I am using MySQL v5.1 on Ubuntu machine.
MySQL on my machine used to work. (Running mysql -u root gave me the MySQL command line.)
This afternoon, I did the following thing:
1. check active process ...
0
votes
1answer
166 views
MySql: LOAD DATA INFILE
I am using MySQL v5.1 on Ubuntu machine.
MySQL data directory is /var/lib/mysql/
I have a test.dat file located on /var/lib/mysql/tmp/test.dat
I would like to load data from the test.dat file into ...
1
vote
1answer
32 views
dump out some tables of the database
I am using MySQL v5.1 on Ubuntu machine.
I have a database named db_test which contain tables like cars, customers, departments, prices , and so on.
I know I can use the following commands to dump ...
1
vote
2answers
166 views
Can I copy a MySQL database by copying the files? What do the files contain exactly?
I am using MySQL database and using an Ubuntu Linux machine.
My database named db_test , I notice that under path /var/lib/mysql/db_test ,there are files suffix with .frm, .MYD, .MYI like following:
...
