From the MySQL – FOREIGN KEY Constraints Documentation: If you re-create a table that was dropped, it must have a definition that conforms to the foreign key constraints referencing it. It must have the correct column names and types, and it must have indexes on the referenced keys, as stated earlier. If these are not … Read more
You have 2 options delete and truncate : delete from mytable This will delete all the content of the table, not reseting the autoincremental id, this process is very slow. If you want to delete specific records append a where clause at the end. truncate myTable This will reset the table i.e. all the auto … Read more
Default is: Username: root Password: [null] The Password is set to ‘password’ in some versions.
The technique in this post worked for me 1) Click the “Export” tab for the database 2) Click the “Custom” radio button 3) Go the section titled “Format-specific options” and change the dropdown for “Database system or older MySQL server to maximize output compatibility with:” from NONE to MYSQL40. 4) Scroll to the bottom and … Read more
To increase the phpMyAdmin Session Timeout, open config.inc.php in the root phpMyAdmin directory and add this setting (anywhere). $cfg[‘LoginCookieValidity’] = <your_new_timeout>; Where <your_new_timeout> is some number larger than 1800. Note: Always keep on mind that a short cookie lifetime is all well and good for the development server. So do not do this on your … Read more
Set / change / reset the MySQL root password on Ubuntu Linux. Enter the following lines in your terminal. Stop the MySQL Server: sudo /etc/init.d/mysql stop Start the mysqld configuration: sudo mysqld –skip-grant-tables & In some cases, you’ve to create the /var/run/mysqld first: sudo mkdir -v /var/run/mysqld && sudo chown mysql /var/run/mysqld Login to MySQL … Read more
For a single table update UPDATE `table_name` SET `field_name` = replace(same_field_name, ‘unwanted_text’, ‘wanted_text’) From multiple tables– If you want to edit from all tables, best way is to take the dump and then find/replace and upload it back.
As stated here: Two most common reasons (and fixes) for the MySQL server has gone away (error 2006) are: Server timed out and closed the connection. How to fix: check that wait_timeout variable in your mysqld’s my.cnf configuration file is large enough. On Debian: sudo nano /etc/mysql/my.cnf, set wait_timeout = 600 seconds (you can tweak/decrease … Read more
Use the following query in sql tab: SHOW CREATE TABLE tablename To view full query There is this Hyperlink named +Options left above, There select Full Texts
If you want to use phpMyAdmin to set up relations, you have to do 2 things. First of all, you have to define an index on the foreign key column in the referring table (so foo_bar.foo_id, in your case). Then, go to relation view (in the referring table) and select the referred column (so in … Read more