linixmysql导入报错

chmod 644 /path/to/your/file.sql

ls /path/to/your/file.sql

GRANT ALL PRIVILEGES ON *.* TO 'your_user'@'localhost';
FLUSH PRIVILEGES;

CREATE DATABASE your_database;
USE your_database;

mysql -u your_user -p your_database < /path/to/your/file.sql

iconv -f utf-8 -t latin1 /path/to/your/file.sql -o /path/to/your/file_converted.sql

sudo dd if=/dev/zero of=/swapfile bs=1M count=1024
sudo mkswap /swapfile
sudo swapon /swapfile

# 确保文件权限正确
chmod 644 example.sql

# 确保数据库存在
mysql -u your_user -p -e "CREATE DATABASE IF NOT EXISTS mydatabase;"

# 导入数据库
mysql -u your_user -p mydatabase < example.sql