SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Read a large .sql script from MySQLWorkBench
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

nsiempba
Starting Member

Canada
1 Posts

Posted - 07/10/2013 :  09:36:25  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2060 Posts

Posted - 07/10/2013 :  16:23:02  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000