1.进入数据库 dbaccess $dbname
2. 导出数据 unload to tablename.unl select * from tablename;
3. 导入数据：load from tablename.unl insert into tablename;
4. 执行sql文件： dbaccess $dbname file.sql
5. 导出所有的数据：UNLOAD TO unload_newdate.sql DELIMITER ';' SELECT "unload to "||tabname||".txt delimiter '|' select * from "||tabname FROM systables WHERE tabid>99
执行完后，再执行 dbaccess $dbname unload_newdate.sql
6. 导入所有的数据：UNLOAD TO load_newdata.sql DELIMITER ';' SELECT "load from "||tabname||".txt delimiter '|' insert into "||tabname FROM systables WHERE tabid>99
执行完后，再执行dbaccess $dbname load_newdate.sql
7. 导出所有的数据：dbexport 前提，数据库得关闭 ； 导入:dbimport
8.执行sql语句：dbaccess hncy smsconfig.sql