Tag Info

New answers tagged

1

Definitely, in a Relational Data Management System, you SHOULD use relationships between your entities. A simple example query where you will be stuck by using the first option : Select all users and role name with roles 1 or 11 You will have to perform character to character searches and comparisons that are much less efficient than relational ...


0

There are several options, but here are two based on two options for how your end-users connect. First, if your users connect as themselves. For example, if you have a user "annamaria" then in your trigger you can identify the user with the CURRENT_USER() function. Record CURRENT_USER() into your auditing table with each modification and you can track ...


1

Depends on what version you are. You can install the audit_plugin: INSTALL PLUGIN server_audit SONAME 'server_audit'; You can choose two outputs, file or syslog. The output format will be: 20140901 15:19:44,localhost.localdomain,root,localhost,4,133,WRITE,employees,salaries, 20140901 ...


0

I solved the problem by following this answer: http://stackoverflow.com/a/11506495/2364405 Except with these changes: On Step 5, I did not find create_tables.sql, but I found create_tables.sql.gz instead. I used WinSCP and downloaded this file, then imported it into phpMyAdmin (This takes care of steps 6 and 7). On Step 8, I only changed the ...


1

I can't leave a comment, because I don't have the rep. You can copy files from one server to the next to move your database. To do this, you must make sure that both instances of your DB are stopped. I also recommend using rsync to copy your database files. In addition to making sure that both database servers are stopped before moving the files, you will ...


0

The tutorial you followed was mine and was the accepted answer. However, the other answer given by AaronBrown had a very strong caveat. Instead of having a single point of failure, now you have three. What if one of the servers goes down? Now replication is broken everywhere: How do you replace it easily and align the binary log positions? ...


1

Often this is the problem: http://php.net/manual/en/mysqli-result.free.php But it is not obvious here. Meanwhile... Don't use OPTIMIZE TABLE; it is almost always useless, especially for InnoDB tables.


2

For INNODB I was able to do the same thing and it didn't cause an error in php. Here is what I did: ALTER TABLE phppos_items FORCE;


1

I just fixed the problem: apt-get remove php5-mysql apt-get install php5-mysqlnd I had to reinstall phpmyadmin, the errors disappeared now.



Top 50 recent answers are included