MySQL – How to Generate Error Log File While Executing .sql File in Terminal

importMySQL

I just started learning coding 2 week ago and I am in a middle of an issue that I am not really able to find online, SO i though why not ask.

I am trying to import Import a MySql DB of around 8 Gigs through Terminal (SSH) But the file execution always stop in the middle somewhere.

My Question is:
Is there a way to write the error log generated my mysql while running the query in terminal backend?
The 2 queries I am using are:

1/mysql -uroot -pxxx -f main < sq2.sql &

2/ gzip -dc < file.sql.gz | mysql -f -uroot -pxxx web &

Both queries run as a back-end daemon because of "&" and "-f" helps in forcing the mysql to run even when an error is encountered.

But still my query gets terminated in the middle, So how can I write and log errors for such commands.

Best Answer

So after a little more searching I found the answer :)

Here is how this needs to be done.

mysql -uroot -xxx! -f main < sq2.sql > /var/www/log.txt &

Related Solutions

Mysql – Error while importing a “.sql” file in database

Since you have an ASCII file, the script could be giving problems because it is came from a Windows machine and you are attempting to load it into mysql on a Linux machine.

You may want to try one of two things:

Using the mysql client in Windows, load the data remotely.
Use sql client in raw mode in one of two ways
- mysql -hIP -r -uroot -p DN_name < filename.sql
- mysql -hIP -B -uroot -p DN_name < filename.sql

MySQL – Why Are Slow Queries Not Logging?

I think I got the answer:

You need to put those options under the [mysqld] section

[mysqld]
slow-query-log=1
slow-query-log-file=/var/logs/my.slow.log
long_query_time=1

and restart mysql

UPDATE 2013-03-05 16:36 EST

I don't know why this is still happening, but please try this:

service mysql stop
rm -f /var/logs/my.slow.log
touch /var/logs/my.slow.log
chown mysql:mysql /var/logs/my.slow.log
service mysql start

then run SELECT SLEEP(10); and see if it lands in /var/logs/my.slow.log

Best Answer

Related Solutions

Mysql – Error while importing a “.sql” file in database

MySQL – Why Are Slow Queries Not Logging?

UPDATE 2013-03-05 16:36 EST

Related Question