Tagged Questions

2
votes
2answers
2k 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: ...
1
vote
3answers
592 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 ...
1
vote
4answers
507 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 ...
1
vote
2answers
1k 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
49 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
268 views

Import single rows from SQLite to MySQL?

I need to do some kind of incremental import again and again from a SQLite 3 database to a MySQL database. Column names are the same in both databases. Is there a good way to do this by a script ...
0
votes
1answer
20 views

Only value required using mysql command

I created following command to get value of Innodb_data_writes using command show status in mysql database. mysql -u root -p**** -e "show status" | grep Innodb_data_writes Current Output: ...
-1
votes
2answers
51 views

Copyed mysql files from previous system now error while connect, what to do?

Fist of all I have the files but the old system is gone. I took the folders in /var/lib/mysql/ and gave then the permissions the mysql folder that was in there had. user mysql group root only ...