Forum Replies Created
-
AuthorPosts
-
CalEvans
Membersubstring, not substr.
If sqlyog doesn't color it, it's not a keyword. 🙂
=C=
MemberQuote:Wouldn't it be a great idea to let sqlyog exclude all the blob fields from the select query when hitting [enter] while still showing the column. Just when a blob-field is clicked the select query to that field can be executed.Nope, it wouldn't. An option would be acceptable as long as it defaults to the current behavior.
One wishlist item I'd like to see is a 'Select Statement for this table' like we have for Insert. This way I can delete the fields I don't want. (Because I have the exact same problem as you do in that respect.) Currently, I'll let SQLyog give me the Insert statement and then I strip out everything and use the field names for the select statement. On my larger tables, this beats typing them by hand.
Don't know about the references. I'm not having that problem.
=C=
MemberI believe you can use the Database Sync Tool (CTRL-W) to do this.
=C=
MemberDoes your server have InnoDB support compiled in?
=C=
MemberQuote:Error No. 2003Cannot connect to Server 192.16.2.10 (10054)
Just a guess here but your pic gies a different IP address than the one in the quote above.
If that's just a typo then try the following standard mysql connection debugging steps.
0: Make sure the server is running.
1: If the server is outside of your network, make sure that port 3306 traffic is not being blocked by a firewall.
2: Make sure you can connect to the server from a client local to that server.
3: Make sure the server is listening to an IP address.
4: Make sure the server is listening to an IP address other than localhost.
5: Make sure WinXP's built in 'protection' as well as any personal firewalls are not blocking your traffic.
6: Try to connect from a different machine.
HTH,
=C=
MemberMemberI concur with the tech form Syware. It would help if you could post the SQL statement he was looking at when he said that.
From the looks of it you are not giving MySQL a unique value for your PK. Have you tried making NTBN auto_increment?
If I understand the problem correctly, when new data is added tot eh PDA and then synced, the Add fails. The add is failing because the conduit is using an insert that is trying to give the PK a value that already exists. The first thing I would try is removing NTBN from the insert statement and making that field auto-increment. This may solve your immediate problem but there may be other ramifications to doing this that I am not aware of. (orphaned records, etc.)
HTH. Cool project. When you get this solved, I'd like to ask more questions.
=C=
MemberNo anwer to your problem but I do have a question.
1: What platform is your PDA?
This looks like a cool project. Did you write the conduit yourself or is it commercial?
=C=
MemberQuote:querying an innoDB table with 18 rows and 10 columns WITH BLOB FIELD takes one minute and 20 seconds, when hitting [enter] after selecting a table (way too long)Ok this depends.
Since we know MySQL is blindingly fast. And we know that SQLYog can keep up with MySQL then we have to look at external factors. (available bandwidth between client and server, size of rows being returned, number of rows being returned.)
So in debugging your application (because this really isn't a bug in either MySQL or SQLYog, it's just your setup) I would suggest you look into the following questions.
1: Is the server remote or local to you?
2: How long does it take to return just 1 row?
3: What's in the blob fields? (1k of text will return a whole lot faster than 1MB of MP3's.)
4: Is it necessary for the application to have access to all 18 of the BLOB fields at once? If not, try filtering your query so that you only return 1 row.
HTH,
=C=
MemberDepends on how creative your ISP allows you to be. It's possible to write a php wrapper for mysqldump. Then call it from a webpage. it would take some experimenting but it would be possible.
=C=
Memberandroidtech wrote on May 17 2004, 03:20 PM:I take it that if you can't open an SSH tunnel then you can't use MySQLDump?Incorrect.
If you can connect to it with SQLyog then mysqldump running on the same machine will connect.
I run my servers so that they only listen to 127.0.0.1. Therefore, to connect from a remote machine I have to tunnel through. If the server is listening to an external IP address then you should be able to use mysqldump.
=C=
MemberYep. I've had this problem for several versions now. Something gets hosed in the INI file.
=C=
MemberGlad to have been of help.
Membermysqldump does not have to be run on the same machine as the server. (check out the –host=name option)
I routinely use it to backup all of my server from a central location. These servers are spread out throughout the Southeast US. Since none of them are available via the Interment directly, I use ssh to create tunnels into machines that can see them. Then mysqldump all of the databases into a file named for the date and server.
Once a week, a script runs that deletes anything that is more than X days old. (I think it's 2 weeks, not sure anymore)
Unless I am misunderstanding your needs, it is entirely possible to simply use mysqldump to do what you are needing to do.
=C=
MemberSorry, I'm now confused.
mysqldump can be run on any computer that SQLYog can be run on. If it's a windows machine, just write a batch file and stick it in the automated folder (or however that works, never had much use for it myself) This way you can do the dump and automate it.
HTH,
=C=
-
AuthorPosts
