Tag Info

Hot answers tagged

4

MyISAM For a MyISAM table mydb.mytable, you should have three files \bin\mysql\mysql5.6.12\data\mydb\mytable.frm \bin\mysql\mysql5.6.12\data\mydb\mytable.MYD \bin\mysql\mysql5.6.12\data\mydb\mytable.MYI They should already be accessible as a table since each file contains needed data, metadata, and index info. Collectively, they form the table. There ...


3

Yes, if you use phpMyAdmin on your WAMP server, you can use the Export tab to dump your database and all the data in it. On the Export tab, choose the Custom export method. This opens a bunch of options. Under Save Output to a File, choose Compression and you get to choose zipped from a drop-down. Then you can Import that zip to another MySQL instance on ...


3

The differences have to do with the expected capacity mysqld is requested to handle my_huge.ini does not have max_connections set has innodb settings commented out values preset sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M my-innodb-heavy-4G.ini has max_connections set at 100 has innodb settings ...


2

You forgot one thing binlog-do-db=our_database binlog-ignore-db=mysql binlog-ignore-db=test replicate-do-db=our_database log-slave-updates The option log-slave-updates takes SQL that was read from relay logs and records them in the Slave Binary Logs when the SQL is completed. Please be very careful. You should never use binlog-do-db and ...


2

In your Error Log : [ERROR] Slave I/O: error connecting to master 'master@192.168.1.100:3306' - retry-time: 60 retries: 86400, Error_code: 2003 Error_code: 2003 : The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has ...


2

The most common cause of this is virus scanning, as virus scanners tend to lock files. Try excluding the directory from scanning.


2

In a WAMP environment, a developer is probably more focused on Coping PHP/Perl/Python Configuring Apache to get the WebServer going Using MySQL to store data, far less concern for the MySQL Utilities and other Bells and Whistles Getting Windows to coordinate the use of Apache, PHP, and MySQL (If you use IIS instead of Apache, that means the environment is ...


2

WAMPServer is primarily designed for use on a single machine i.e. a developer writing and testing code locally on that PC. So to protect the beginner from his/her self the Apache & MySQL configuration by default is setup so no access can be made to the Apache or MySQL server form anywhere but the PC running Apache and MySQL. When changing this ...


1

If you are access PHPMyAdmin from another LAN location then the Apache server needs to be able and willing to accept connections from other than localhost. This will probably mean simply ensuring that the port (80 by default) is open to the LAN and that Apache is likewise willing to serve to remote addresses (which I would expect it to unless you have a very ...


1

I would so something like this. I presume that your patients will visit more than once and you will need a data set for each visit. Of course, you will need to add more columns, but this structure should allow for flexibility for reporting as well as data entry. CREATE TABLE Teeth ( ToothID INT NOT NULL PRIMARY KEY IDENTITY(1,1) , ToothPosition INT NOT ...


1

Even with all the changes you have implemented in my.ini, I would like to suggest just one more: I noticed you did not set innodb_buffer_pool_instances. According to the MySQL Documentation, this is what innodb_buffer_pool_instances is for: The number of regions that the InnoDB buffer pool is divided into. For systems with buffer pools in the ...


1

For something like this, you may want to think about a unique architecture known as a Star Topology. Picture the following: Server HQDB with 25 databases (1 for each branch) Server BranchDB001 with database `branch001`` Server BranchDB002 with database branch002 ... Server BranchDB025 with database branch025 Setup Data for HQDB On HQDB, create the 25 ...


1

The authors of High Performance MySQL describe part of your problem fairly succinctly (p. 234): MySQL can’t execute a single query in parallel on many CPUs. This is a feature offered by some other database servers, but not MySQL. Running a single stored procedure will use no more than 1 of your CPU cores for executing queries, with a little extra on ...


1

Here is the only thing I can advise for now: Open a DOS Window and run the following C:\> dir mysql.user /s If you see two mysql.user files, then you may have two DB setups. You would just have to point datadir in my.cnf back to the old setup. Please find out and let me know ...


1

Whether you have Server configured with WAMP or as a Dedicated DB, the concepts for setting up multimaster replication is identical. Before I go on, let me clarify the phrase multimaster replication. True multimaster replication would have a Slave with Multiple Masters. It is not possible at present. MySQL 5.6 is approaching this. I think MariaDB as well. ...


1

When MySQL is really slow on windows (not 30ms slower) is nearly always a matter of a forgotten localhost instead of 127.0.0.1 in settings or URL. Very few times it is due to a very slow fragmented hard drive (acting slower due to windows complex ACL and parallel processes using it). MySQL is slower in some benchmarks on windows but the difference is so ...


1

I have a suggestion On the Slave run the following: STOP SLAVE; CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=95849; START SLAVE; SELECT SLEEP(15); SHOW SLAVE STATUS\G This will reset all relay logs and attempt to connect from the log file and position from the error message. If you get Slave_IO_Running: Connecting, there are two ...



Only top voted, non community-wiki answers of a minimum length are eligible