I Love Sqlyog, But Now What?

[marquix]

Hi everyone,

I found this software in my free time as I was exploring my interest in learning more about mySQL. I essentially put together Joomla and WordPress websites but started to learn more about how the database sort of works when before it just seemed like this far away mysterious hidden database somewhere I couldn't really see or grasp the way I can see create and modify a graphic for example. My question is now what? I was able to connect using tunnel, make changes (that saved me tons of time) and even back up the database (which did not appear identical to the one phpmyadmin makes).

Now what I ask because my thoughts were along the lines of making my SEO work a little easier. Learning how to create content without having to use the interface and begin to understand content for what it is. Pure text, nothing really more but information, DATA. Does anyone know of any real world training that I can get for direct database content building or methods that builders use? Also, I've had people ask me to create like a Multiple Listing Service database from scratch but I just do not know how yet. What would someone suggest I do to learn the tricks that people do stuff with using SQLyog. I'm sure everyone has their shortcuts and methods of doing things. I have a mysql for beginners audio but it seems too boring and so far away from real usage. I almost wish I could work for someone part time or for free just for the experience but it's difficult around here since I live in Mexico.

Any comments would be greatly appreciated. I'm essentially a home taught wannabe trying to survive and move up in this exciting and profitable IT world.

I have a new computer I purchased solely for working with SQL or Linux (not sure what to do with it yet) and just have the curiosity what guys like you would have on a computer for database work. What assortment of programs, OS, or trinkets make up a DB Admin toolkit? I'm a wannabe trying to hang out with the big boys and just learn a bit on the way. Like I said, any advice will be greatly appreciated.

Saludos !

Marco

[DonQuichote]

'marquix' wrote on '15:

Hi everyone,

I found this software in my free time as I was exploring my interest in learning more about mySQL. I essentially put together Joomla and WordPress websites but started to learn more about how the database sort of works when before it just seemed like this far away mysterious hidden database somewhere I couldn't really see or grasp the way I can see create and modify a graphic for example. My question is now what? I was able to connect using tunnel, make changes (that saved me tons of time) and even back up the database (which did not appear identical to the one phpmyadmin makes).

For making a backup, the data is read and a backup is distilled from that. Both programs do that in their own way.

'marquix' wrote on '15:

Now what I ask because my thoughts were along the lines of making my SEO work a little easier. Learning how to create content without having to use the interface and begin to understand content for what it is. Pure text, nothing really more but information, DATA. Does anyone know of any real world training that I can get for direct database content building or methods that builders use? Also, I've had people ask me to create like a Multiple Listing Service database from scratch but I just do not know how yet. What would someone suggest I do to learn the tricks that people do stuff with using SQLyog. I'm sure everyone has their shortcuts and methods of doing things. I have a mysql for beginners audio but it seems too boring and so far away from real usage. I almost wish I could work for someone part time or for free just for the experience but it's difficult around here since I live in Mexico.

I think you are trying to work “backwards”. Long ago, you gad to write queries or modify the source code of a site to make any changes to a site. The content management systems exist to make the changes easier than directly in the source or in the database. If SEO stands for Search Engine Optimization, I think the CMS is probably the easiest tool, or at least it should be. SQLyog is more like a swiss army knife: it can do almost anything, but it may not be the best tool for all everyday tasks.

'marquix' wrote on '15:

Any comments would be greatly appreciated. I'm essentially a home taught wannabe trying to survive and move up in this exciting and profitable IT world.

Okay. First, let me tell you I am a programmer. I write programs in an evolving way: they start small and grow. The databases have to grow with them, in both structure and data. I wrote the following howto about that:

http://www.howtoforge.org/node/4833

Also, if you want to transfer changes on your development database to a production database, it can be good to see what queries were actually sent to the database (by a CMS, for example). To do that, enable the query log in either my.ini (Windows) or my.cnf (Linux) on your development machine and use a program like Baretail to monitor it.

'marquix' wrote on '15:

I have a new computer I purchased solely for working with SQL or Linux (not sure what to do with it yet) and just have the curiosity what guys like you would have on a computer for database work. What assortment of programs, OS, or trinkets make up a DB Admin toolkit? I'm a wannabe trying to hang out with the big boys and just learn a bit on the way. Like I said, any advice will be greatly appreciated.

I use SQLyog (off course), DBDesigner for the design work (alas it is getting quite old, but I will never switch to MySQL workbench), Baretail, the MySQL command-line tools and subversion (both command-line and through TortoiseSVN).

I do a lot from the command-line and can update a site by starting one script: that script updates the PHP and SQL source from subversion, “builds” the SQL recreate script and runs it. I do this on my development machines as well. This way, working at home is almost as easy as working at the office, and every update for a development machine is a test for a an update on the live server.

'marquix' wrote on '15:

I have a new computer I purchased solely for working with SQL or Linux (not sure what to do with it yet)

The combination (Linux AND MySQL) is very common. So you may do both. You can even keep on using SQLyog if you install wine (a system to run Windows programs on Linux). I have this setup at home and at work and it works like a charm. If you want to keep Windows on that machine (I suspect it comes with Windows preinstalled), you may set up a dual boot configuration or you may even install Linux inside the windows partition. If you run Linux inside a virtual machine, you can have Windows and Linux running at the same time.

[Author]

Posts