Forum Replies Created
-
AuthorPosts
-
CalEvans
MemberWhen you export the structure you don't get the KEY and PRIMARY KEY lines? I get them every time. (And I export at least 1-3 a day.) What version fo SQLyog are you using?
=C=
MemberHow would sftp be beneficial to a program that connects to sql servers?
=C=
MemberBooBoo wrote on Jul 29 2003, 06:54 PM:In phpMyAdmin, you have to reload the database after adding a user or modifying the users permissions. This is the reload that I am referring to. If it can be done via a script, then what is the script command to do this?Thanks!
This is more of a defect in phpmyadmin than a feature than needs to be in sqlyog.
If you use the user/permissions manager in sqlyog, you can make changes without having to FLUSH PRIVILEGES
If you edit the permissions tables in the mysql database directly, then you do have to issue a FLUSH PRIVILEGES before the changes will take affect.
You can issue any of the FLUS commands form the command window though. The only thing you can't do is restart the service. (and I argue that that is a 'feature' you don't want in a client!)
HTH,
=C=
MemberWhat versio0s of SQLyog and Mysql? I'm using MySQL 4.0.13 and SQLyog 3.52 and don't have this problem.
=C=
MemberWhat table type is mtv20030105spots?
Is the SERVER on windows or Linux?
What version of SQLyog are you using?
While I can't run your query because I don't have the original table, I just ran the Copy Table o an existing table in my tst database and it works fine. (MySQL 4.0.13 on Linux, client 3.52 on on Win2k)
=C=
MemberPretty much you just can't do that. The import is basically a seriese of inserts, one for each record.
YOur best bet is to use something like Excell to stitch the fields together into records, then save the final as a csv. Then try and import that.
HTH,
=C=
MemberMemberWhat version of SQLyog are you using?
Also, if you would :
Try it again
Then look at the history window and execute the commands one at a time.
Then post here with the command that is throwing the error.
FWIW, I'm experiencing a similar issue.
=C=
MemberI've been getting this too of late and it stems from the lock command. When exporting, you have the toption to lock the tables for read, uncheck that and try it again.
=C=
MemberHi John,
It doesn't work that way with MySQL. In ASP, you use ADO to execute the SQL directly. The result should be your resultset that you work with.
Sorry Not sure how to relate this to Dreamweaver.
HTH,
=C=
MemberWhat kind of mouse? I've got a Kensington Expert Mouse PRO and a Logitech keyboard with a scroll wheel and both will scroll the query window just fine. (Up and down.)
=C=
Member4 suggestions:
1: get more RAM
2: Check out the sample cnf files. There is one for large systems. Read it over carefully, it may contain some insight.
3: Use EXPLAIN on your query to see if another index would help.
4: post on the mysql mailing lsit. There are guys there who have crossed this bridge before (Jeremy Zawoodny for one…and I know I misspelled his name)
=C=
MemberContact your ISP and ask them if you CAN connect to the MySQL server from the outside (Some do not allow this) and if so, what the hostname, login and password are. It would be foolhardy of them to have setup your ftp and your mysql login and passwords exactly the same.
=C=
MemberI can't either
3.23.56
[9:36:42 PM][ 0 ms] optimize table `intranet`.`zipData`, `intranet`.`tradingPartner`, `intranet`.`sequence`, `intranet`.`sanno`, `intranet`.`roleList`, `intranet`.`role`, `intranet`.`queue`, `intranet`.`person_role`, `intranet`.`person`, `intranet`.`one`, `intranet`.`message`, `intranet`.`mailingList_account`, `intranet`.`mailingList`, `intranet`.`inventoryUpdateMessages`, `intranet`.`inventoryHolding`, `intranet`.`ediBatch`, `intranet`.`doNotMail`, `intranet`.`business`, `intranet`.`applicationParameters`
=C=
MemberWHen you established your relationship did you build any constraints? Sounds like you did and the new rows are violating the constraints.
=C=
-
AuthorPosts
