Kurinchilion.com » Linux Windows Enterprise Solutions
HeidiSQL - a comprehensive tool for MySQL management which is available for Free.
Manage data tables, export/import databases, synchronise tables between databases, integrity check, database backup service management, edit database content and many more features packaged as a solution for ALL your MySQL needs.
This runs on windows platforms – WinXP/XP7 and you can download HeidiSQL from Download link
(more…)
When moving mysql database from one server to another or, to test that the data backup works as expected we need to import mysql dump file in the testing environment.
Create the database (test-database) in the testing environment and identify the location of the .gz or .sql file.
If the mysql dump was a .gz file, you need to gunzip to uncompress the file by typing
$ gunzip mysqldump.sql.gz
This will uncompress the .gz file and will just store mysqldump.sql in the same location.
(more…)
To clear the screen content in MySQL use the command
mysql> \! clear
Usage of “\!” tells MySQL to pass the command to Linux OS to handle the request.
If you are in a Windows environment (DOS prompt), to pass the control to the OS you can use the command
mysql>system cls
Reason why this error might occur:
i) Incomplete MySQL implementation
ii) MySQL setting mis-configuration
Solution:
root@myserver:/# vi /etc/mysql/my.cnf
Comment out the below line in my.cnf file to make MySQL listen on ALL interfaces
#bind-address = 127.0.0.1
root@myserver:/# netstat -tap | grep mysql
tcp 0 0 *:mysql *:* LISTEN 17785/mysqld
Note that above line which indicates MySQL listening on all interfaces.
In order for you to export data from MySQL to Access database, you need to first download MySQL ODBC connector from
http://dev.mysql.com/downloads/connector/odbc/3.51.html
(Choose MSI installer from the downloads section and install it in your machine)
After installing MySQL ODBC connector, you need to configure ODBC connector in order connect MySQL database.
1. Choose Start > settings > Control Panel > Administrative Tools. Then double click on Data Sources (ODBC)
2. Click System DSN and then press “Add” button. There will be a dialog asking you to choose new data source. Choose MySQL ODBC 3.51 driver and click Finish
3. Next you need to fill in the details that will enable ODBC drive to open the database of your choice. Give a name for the data source (e.g. MyDSN), Server name (e.g. localhost), User (e.g. sqlusername), Password (password for user sqlusername) and the name of the database to which you want to connect to in MySQL
4. Click the Test button to ensure everything works fine and as expected.
5. The DSN “MyDSN” gets created for you when you click the “Ok” button.
6. Now, go to Access and create a database (e.g. MyAccessDB)
7. In Access, click “File > Get External Data > Import > and then choose “ODBC Databases” from “Files of Type” option. This will open a new dialog window asking you to “Select Data Source”
8. From the new dialog window, choose “Machine Data Source“. This will display the DSN “MyDSN” which you have created earlier. Choose that DSN and click “Ok” to import the database from MySQL to Access database.
Command to clear the screen content from command prompt in MySQL
mysql> \! clear
Ever wondered why there is a “test” database in the list of tables when you install MySQL.
This is to allow users to practice MySQL commands or execute complex queries on the database.
“test” database is accessible to everyone who has access to MySQL in your localhost and hence is not advisable if you were to use it for your development. (more…)
Quick and easy steps
Grab a copy of cakePHP from cakephp.org website
You can either create the new cakephp website in the root (http://localhost/) or by adding it as a subfolder (http://localhost/mycakesite/)
If you create it as a subfolder, then configure the appropriate path settings for linking images in the web pages.
(more…)
MySQL Table Types that are well known
- MyISAM
- InnoDB
- BSD
When making a choice amongst the different types of tables in MySQL, we need to consider the following points
- Size of database based on the activity
- Nature of database access / activity (whether it involves heavy reads / writes)
- Database backup (schema, data)
- Session handling
- If it involves a sync to another database
- What needs to be done if the application is to be scaled
(more…)
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Aug | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | |||
Entries (RSS) Designs by Kurinchilion Inc. All rights reserved.