Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
snowy
Starting Member
5 Posts |
 Posted - 2011-01-14 : 23:47:40
|
| Hi I'm using MySQL Server 5.1. I'm having a problem where I try running a "employees.sql" file inside the MySQL command line clientby using the command "source C:/directoryA/employees.sql;" and it executes sucessfully inside the prompt. All my tables are created and they all have their data. The problem is as soon as I close the command line client and open it up later, they're not there anymore. It's like they are not being committed at all. Even if i put a "commit;" at the end of the sql file it makes no difference. I also found that if i run that file then switch databases and then come back the tables are not there anymore.Anyone know what I'm doing wrong and how to make sure the tables are permanently there?I obtained the sql file from this tutorial[url]http://www.devx.com/Java/Article/29309[/url]it's in the "download the scripts".Thanks. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-15 : 00:28:27
|
| This is an only MS SQL Server forum.Try posting it in mysql forum http://forums.mysql.com/PBUH |
 |
|
|
|
|
|
Can't commit my tables from a *.sql file