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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Read a large .sql script from MySQLWorkBench

Author  Topic 

nsiempba
Starting Member

1 Post

Posted - 2013-07-10 : 09:36:25
I trying to read the data contained in an .sql file. To do this, I installed MySQL WorkBench. I used Edit SQL Script option to read the file but the file is too big and i receive the message «Can't Open SQL script, Large file....» I also tried to open this file with manage import/export option. but i received this message
[Error 3] Le chemin d?acc?s sp?cifi? est introuvable: 'C:\\Users\\Test\\Documents\\dumps/*.*'
09:02:33 Restoring C:\Users\Test\Desktop\Tools\BD-Public - Copie\L33tCrew.sql
Running: mysql.exe --defaults-extra-file="c:\users\test\appdata\local\temp\tmpaorekx.cnf" --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "C:\\Users\\Test\\Desktop\\Tools\\BD-Public - Copie\\L33tCrew.sql"
09:18:02 Import of C:\Users\Test\Desktop\Tools\BD-Public - Copie\L33tCrew.sql has finished

tables appear to have been read but I do not see data

thank's for your help...

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-07-10 : 16:23:02
Assuming you're talking about MySQL. This is a SQL Server forum - you might want to try a MySQL forum

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -