Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberHello
You can do that. Just specify those databases in the database(s) field of the connection window
HTH
Ritesh
MemberThanks 😀
We will work on it.
Ritesh
MemberHello
Are you using Tools->Execute Batch File… option or you are using the SQL Window to execute the queries.
Ritesh
MemberQuote:two different connectionsAre you connected to the same MySQL Host.
Neway, thanks for the report 😀
Ritesh
MemberQuote:SQLyog will failDo you mean that SQLyog is crashing?
You can override an existing table during ODBC Import. Click on the Transform button for the specified table in the Select Table(s)… page of the wizard. Check the Drop and Recreate Table… option in the Column Mapping and Transformation dialog.
HTH
Ritesh
MemberSQLyog uses MySQL's Load Local Infile… command to import data from a CSV file. SQLyog does not generate a log file to show you the complete details.
Ritesh
MemberHello
SQLyog writes the query and the error in sqlyog.ini. The file is located in the directory where SQLyog is installed. Can you give us the exact error with query?
Ritesh
MemberSorry 🙁 but there is no option to deactivate backticks
Ritesh
MemberIn the Export Database As Batch Script… dialog uncheck the option Flush Logs Before Dump
HTH
Ritesh
MemberThanks 😀
Ritesh
MemberThanks for the suggestion.
You can install a generic Proxy Client and SQLyog with work without requiring any configuration.
HTH
Ritesh
MemberHello
Except the secheduler job(s) you can do everything in MySQL. In most of the cases, MySQL will perform better then what you expected 😀
For the schedued job you can write your own app that will run as a service and do your job.
SQLyog has been tested to work under such condition(s) and it has come out with flying colours. Many of our customers have used it in even more heavy situation and didnt have any problem.
Best of all, SQLyog and MySQL are FREE !!! 😀
HTH
Ritesh
MemberTry this –
After you give the DSN information, SQLyog will ask you whether you want to import data from the datasource or through a query.
Select Use a query to specify the data, then in the next wizard write a query something like select * from tablename . SQLyog will list you the result with all the columns. Select them and import it. Please post the result out here for our information.
HTH
Ritesh
MemberPress Ctrl+N . Give the details for the other DB ( you can also save it ) and press connect.
HTH
Ritesh
MemberNormally it should not cause a problem.
How big is the database? If its not very big then you can send me a backup of the DB so that I can give it to my development team to correct the error ( if there are any )
-
AuthorPosts