26 lines
654 B
Batchfile
26 lines
654 B
Batchfile
|
@echo off
|
||
|
|
chcp 65001 >nul
|
||
|
|
echo.
|
||
|
|
echo ========================================
|
||
|
|
echo 🔄 重新导入数据库
|
||
|
|
echo ========================================
|
||
|
|
echo.
|
||
|
|
|
||
|
|
echo 步骤 1: 删除 ai 数据库
|
||
|
|
mysql -uroot -prootx77 -e "DROP DATABASE IF EXISTS ai;"
|
||
|
|
|
||
|
|
echo 步骤 2: 创建 ai 数据库
|
||
|
|
mysql -uroot -prootx77 -e "CREATE DATABASE ai CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
|
||
|
|
|
||
|
|
echo 步骤 3: 导入数据
|
||
|
|
mysql -uroot -prootx77 ai < 数据库.sql
|
||
|
|
|
||
|
|
echo.
|
||
|
|
echo ✅ 导入完成！
|
||
|
|
echo.
|
||
|
|
echo 验证结果:
|
||
|
|
mysql -uroot -prootx77 -e "USE ai; SELECT COUNT(*) as table_count FROM information_schema.tables WHERE table_schema='ai';"
|
||
|
|
|
||
|
|
echo.
|
||
|
|
pause
|