Jump to content
  • 0

[MySQL] Problem 'Executing' db/sql-files


Deleted User

Question


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  235
  • Reputation:   55
  • Joined:  12/02/11
  • Last Seen:  

Hello, i've been 'NEW' with MySQL i mean new interface of MySQL work Bench. i'm just asking for help why i got 'Windows Not Responding'

Though i 'Execute' the files properly, just like the OLD MySQL (easily to import and execute).

Preview:

(1)

post-630-0-09530700-1331297132_thumb.png

Preview [After waiting for mins):

(2)

post-630-0-17197000-1331297525_thumb.png

Guide from 'WiKi' i followed : http://rathena.org/wiki/Installing_SQL

NOTE: i'm trying to switch to newer version of MySQL softwares. i only want some Guides or Tips how to do that exactly since i'm new with New MySQL.

Yours,

Kaze

Edited by Kaze
Link to comment
Share on other sites

6 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

Hi Kaze,

I'm not very familiar with using MySQL Workbench, however, try to look for a non-verbose method of importing/executing the SQL file. I believe the fact that the item_db.sql is an extremely long query gets your program stuck when it's trying to process it.

So try to look for a way to import the file, without it displaying everything.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  235
  • Reputation:   55
  • Joined:  12/02/11
  • Last Seen:  

Hi Kaze,

I'm not very familiar with using MySQL Workbench, however, try to look for a non-verbose method of importing/executing the SQL file. I believe the fact that the item_db.sql is an extremely long query gets your program stuck when it's trying to process it.

So try to look for a way to import the file, without it displaying everything.

Hello, Asura! thanks for the quick respond, yes, I'm also not familiar with MySQL Workbench this is New MySQL. i'm using the OLD one that's why i'm getting hard and not familiar with the NEW Interface of this. i'll try to look for new method of executing it, however i'm still configure it out how many 'TIMES' i drop my schema and Execute but it fails, so i'll try to look for it.

I'm confuse why the MySQL Work Bench doesn't load with Long 'Querys' though the OLD version is working fine for me.

Just confuse!

Thanks again!

Bump~

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  47
  • Topics Per Day:  0.01
  • Content Count:  633
  • Reputation:   78
  • Joined:  11/14/11
  • Last Seen:  

Try using MySQL Browser Tool.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  235
  • Reputation:   55
  • Joined:  12/02/11
  • Last Seen:  

Try using MySQL Browser Tool.

Would you mind to give me the TOOLS for MySQL?

I'm wanted to SWITCH with new MySQL work bench right? everytime i execute with 'Long Query' it will Windows Error.exe responding/

I'm just confuse with that thingy.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  47
  • Topics Per Day:  0.01
  • Content Count:  633
  • Reputation:   78
  • Joined:  11/14/11
  • Last Seen:  

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  235
  • Reputation:   55
  • Joined:  12/02/11
  • Last Seen:  

Bump~ why does i got windows.exe error when importing my db/sql-files?

unless if it can't be sold i will use my OLD MySQL.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...