Forum Replies Created
-
AuthorPosts
-
RiteshMember
You can fetch filtered data by using the correct where clause in the SQL statement and executing it with using F8 instead of F5 and Shift+F5
RiteshMemberQuote:is there any way to trace it?No 🙁
Is it happening regularly or once in a while :huh:
RiteshMemberQuote:I do an insert from a web page nothing happens. All the numbers are 1Try inserting a row through SQLyog.
If it doesnt work then it will be very helpful if you could paste the table structure and the insert statement generated by SQLyog out here 😀
RiteshMemberThere is a known problem with some libraries of RH8 which causes this error.
This error has been discussed lot of times in the MySQL Mailing List also. If you visit the RH site, they have posted a solution to this problem where you need to upgrade your libraries. This will fix the problem 😀
RiteshMemberIts one of the top item in TO-DO list 😀
RiteshMemberCan you tell us the operation which you were performing when SQLyog crashed?
RiteshMemberQuote:All the fields type date with value Null if the record is updated becomesPlease check out ( or paste it here ) the SQL script generated by SQLyog to update the data.
You can get the query in the History of ResultWindow.
It will be very helpful if you could give us the Create Table statement of your table 🙂
RiteshMemberCan you send us your table structure and a sample data so that we can work on the problem at our side. You can generate SQL scripts for your database by using SQLyog's DB->Export Database As Batch Scripts…. option.
RiteshMemberCan you send us sample data so that we can work on it and fix the bug ( if there are any )? You can send them to [email protected]
Thanks for your help.
RiteshMemberQuote:“Can't connect to MySQL server on localhost '(10061)'.What values are you giving in the Connection Window?
It seems that you are connecting to Localhost instead of your RH8 machine. In the MySQL Host Address , provide the IP or Host Address of your RH8 machine.
Hope it helps.
RiteshMemberQuote:in SQLyog 3.1 it allows to export just ONE table (because after the first export the “export” button is disabled). Please leave it enabled because when you have to export 10 tables it's boring to open “Export data” 10 times.Select all the 10 tables in the first instance. You can select multiple tables 😀
Quote:if you select “Create bulk insert statement” in the “Export data” window the file created by SQLyog 3.1 has a line containing just a “;” after every create table of empty tables.Thanks for the report.
RiteshMemberAll's well that ends well 🙂
Found the bug. We had put up the beta version of SQLyog 3.1 up there which had some changes in Copy Database… option ( probably this was a nasty change ).
Yesterday, we uploaded the new .exe ( i.e. the release version ). Somethings seems to be gone wrong that time 🙂
RiteshMemberPlease try the link above and see what happens? Its bewildering 😮
RiteshMemberSomethings wrong with our forum probably 😀
There seems to be some confusion as the Copy Database… option is perfect. You can check out the screenshot at this link Screenshot. Are you expecting something different?
-
AuthorPosts