Hi everyone,
I have a mysqldump that was a relatively large file(8gb) and I split it into 238 manageable files. I created a bash script to loop through each of the files, but am getting an error. What am I doing wrong on the /usr/bin/mysql -e 'source... ' line?

Thanks all.


Here's the script:


#! /bin/bash
i=0
for ((i=0;i<239;i++))
do
echo "Processing $i.sql"
/usr/bin/mysql -e 'source $i.sql'
done



And I'm receiving the following error for each iteration:

Processing 233.sql
ERROR at line 1: Failed to open file '$i.sql', error: 2
Processing 234.sql
ERROR at line 1: Failed to open file '$i.sql', error: 2
Processing 235.sql
ERROR at line 1: Failed to open file '$i.sql', error: 2
Processing 236.sql
ERROR at line 1: Failed to open file '$i.sql', error: 2
Processing 237.sql
ERROR at line 1: Failed to open file '$i.sql', error: 2
Processing 238.sql

Did you try to run this on any individual sql file and see whether it gives the same error or not? It seems like it can't read the sql files so did u check the file permissions also just in case.

Thanks for the quick response. Permissions are ok(all owned by root). inside mysql I can run the first file, and mysql -e doesn't error:

mysql> source 0.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

[root@ao_bn individual_sql_files]# mysql -e 'source 0.sql'
[root@ao_bn individual_sql_files]# /usr/bin/mysql -e 'source 0.sql'
[root@ao_bn individual_sql_files]#

Following up to my post. I found a solution:

/usr/bin/mysql -e 'source $i.sql'


Should have double quotes:
/usr/bin/mysql -e "source $i.sql"