Here is where the repair button is:

![alt text][1]


  [1]: http://i.stack.imgur.com/4zbUr.png

Run this from your server&#39;s command line:

     mysqlcheck --repair --all-databases



I had the same issue when my server free disk space available was 0

You can use the command (there must be ample space for the mysql files)

    REPAIR TABLE `&lt;table name&gt;`;
for repairing individual tables 

Connect to your server via SSH 

then connect to your mysql console

and 

    USE user_base
    REPAIR TABLE TABLE;

#-OR-


If there are a lot of broken tables in current database:

    mysqlcheck -uUSER -pPASSWORD  --repair --extended user_base

If there are a lot of broken tables in a lot of databases:

    mysqlcheck -uUSER -pPASSWORD  --repair --extended -A

When I got this error:


&gt;\#145 - Table &#39;.\engine\phpbb3_posts&#39; is marked as crashed and should be repaired

I ran this command in PhpMyAdmin to fix it: 

    REPAIR TABLE phpbb3_posts;

This means your MySQL table is corrupted and you need to repair it. Use 

    myisamchk -r /DB_NAME/wp_posts

from the command line. While you running the repair you should shut down your website temporarily so that no new connections are attempted to your database while its being repaired.

**Here is simple steps.**

Go to phpmyadmin and checked that table which one crushed and then select Repair table option.

[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/jG5Ft.png

I had issues with my general log on my dev server. I was able to run the following in the mysql cli to fix the issue.

    truncate table general_log;

Note, this will delete all the contents of the table.

I would like to contribute to a certain project in [GitHub][1]. Should I **fork** it? **Branch** it? What is recommended and how to do it?

  [1]: http://en.wikipedia.org/wiki/GitHub


How do I contribute to other&#39;s code in GitHub?

Is there a way to get `find` to execute a function I define in the shell?

For example:

    dosomething () {
      echo &quot;Doing something with $1&quot;
    }
    find . -exec dosomething {} \;

The result of that is:

    find: dosomething: No such file or directory

Is there a way to get `find`&#39;s `-exec` to see `dosomething`?





&#39;find -exec&#39; a shell function in Linux

I am getting this error in wordpress phpMyadmin

    #145 - Table &#39;./DB_NAME/wp_posts&#39; is marked as crashed and should be repaired 

When I login to phpMyadmin, it says wp_posts is &quot;in use&quot;

My website is currently down because of this.

I googled this problem, but I don&#39;t see the &quot;repair&quot; button on phpMyadmin. Please let me know how to fix this. I am not sure where to issue PHP command. Please advise, my proficiency with PHP is very basic.

Table is marked as crashed and should be repaired

I am getting this error in wordpress phpMyadmin
<pre><code class="hljs language-kotlin">#145 - Table './DB_NAME/wp_posts' is marked as crashed and should be repaired 
</code></pre>
When I login to phpMyadmin, it says wp_posts is "in use"
My website is currently down because of this.
I googled this problem, but I don't see the "repair" button on phpMyadmin. Please let me know how to fix this. I am not sure where to issue PHP command. Please advise, my proficiency with PHP is very basic.

I&#39;m trying to setup up MySQL on mac os 10.6 using Homebrew by `brew install mysql 5.1.52`.

Everything goes well and I am also successful with the `mysql_install_db`.  
However when I try to connect to the server using:

    /usr/local/Cellar/mysql/5.1.52/bin/mysqladmin -u root password &#39;mypass&#39;

I get: 

&lt;pre&gt;
/usr/local/Cellar/mysql/5.1.52/bin/mysqladmin: connect to server at &#39;localhost&#39; 
failed error: &#39;Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: NO)&#39;&lt;/pre&gt;

I&#39;ve tried to access `mysqladmin or mysql using -u root -proot` as well,  
but it doesn&#39;t work with or without password. 

This is a brand new installation on a brand new machine and as far as I know the new installation must be accessible without a root password. I also tried:

    /usr/local/Cellar/mysql/5.1.52/bin/mysql_secure_installation

but I also get 

&lt;pre&gt;
ERROR 1045 (28000): Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: NO)&lt;/pre&gt;



brew install mysql on macOS

I had this previously in my normal mysql_* connection:

    mysql_set_charset(&quot;utf8&quot;,$link);
    mysql_query(&quot;SET NAMES &#39;UTF8&#39;&quot;);

Do I need it for the PDO? And where should I have it?

    $connect = new PDO(&quot;mysql:host=$host;dbname=$db&quot;, $user, $pass, array(PDO::ATTR_ERRMODE =&gt; PDO::ERRMODE_EXCEPTION));

PHP PDO: charset, set names?

I have a function that updates three tables, but I use three queries to perform this. I wish to use a more convenient approach for good practice.

How can I update multiple tables in MySQL with a single query?

MySQL, update multiple tables with one query

Is there any better performance when querying in (particularly) mysql of the following:

    SELECT * FROM `table` WHERE `unix_date` BETWEEN 1291736700 AND 1291737300

over:

    SELECT * FROM `table` WHERE `unix_date` &gt;= 1291736700 AND `unix_date` &lt;= 1291737300

or BETWEEN syntax is just being substituted with the second sql?

What&#39;s mysql&#39;s &quot;BETWEEN&quot; performance over..?

I have a `price` column in `products` table.

I wonder which MySQL type is the most suitable for this column. Is it `DECIMAL`, `FLOAT`, or something else ?

The price can be for example: `139.99`, `40`, `14.5` (2 digits after the decimal point, like in shops).

Please advise.

What MySQL type is most suitable for &quot;price&quot; column?

Let&#39;s say I insert the document.

    post = { some dictionary }
    mongo_id = mycollection.insert(post)

Now, let&#39;s say I want to add a field and update it. How do I do that? This doesn&#39;t seem to work.....

    post = mycollection.find_one({&quot;_id&quot;:mongo_id}) 
    post[&#39;newfield&#39;] = &quot;abc&quot;
    mycollection.save(post)

How do I update a Mongo document after inserting it?

How do I design the database to calculate the account balance?

1) Currently I calculate the account balance from the transaction table
In my transaction table I have &quot;description&quot; and &quot;amount&quot; etc..

I would then add up all &quot;amount&quot; values and that would work out the user&#39;s account balance.

-----------
I showed this to my friend and he said that is not a good solution, when my database grows its going to slow down???? He said I should create separate table to store the calculated account balance. If did this, I will have to maintain two tables, and its risky, the account balance table could go out of sync.

Any suggestion?


**EDIT**: OPTION 2: should I add an extra column to my transaction tables &quot;Balance&quot;.
now I do not need to go through many rows of data to perform my calculation.

Example
John buys $100 credit, he debt $60, he then adds $200 credit.

Amount $100, Balance $100.

Amount -$60, Balance $40.

Amount $200, Balance $240.

Database design: Calculating the Account Balance

 - `null=True`
 - `blank=True`
 - `default = 0`


What&#39;s the difference? When do you use what?

In Django models.py, what&#39;s the difference between default, null, and blank?

I am using a Postgresql database in my rails application.
To store large file or data in database I have used blob data type in MySql. 

For Postgres which data type I have to use instead of blob in MySql?

how to use Blob datatype in Postgres

I always thought that databases should be denormalized for read performance, as it is done for OLAP database design, and not exaggerated much further 3NF for OLTP design.  
 
PerformanceDBA in various posts, for ex.,  in [Performance of different aproaches to time-based data][1] defends the paradigm that database should be always well-designed by normalization to 5NF and 6NF (Normal Form).  

Have I understood it correctly (and what had I understood correctly)? 

What&#39;s wrong with the traditional denormalization approach/paradigm design of OLAP databases (below 3NF) and the advice that 3NF is enough for most practical cases of OLTP databases?  

For example:   

  - [&quot;The simple truth ... is that 6NF, executed properly, is the data warehouse&quot; (PerformanceDBA)][2]    
 
I should confess that I could never grasp the theories that denormalization facilitates read performance. Can anybody give me references with good logical explanations of this and of the contrary beliefs?

What are sources to which I can refer when trying to convince my stakeholders that OLAP/Data Warehousing databases should be normalized?   

To improve visibility I copied here from comments:  

&gt; &quot;It would be nice if participants would
&gt; add (disclose) how many real-life (no
&gt; science projects included)
&gt; data-warehouse implementations in 6NF
&gt; they have seen or participated in.
&gt; Kind of a quick-pool. Me = 0.&quot; – Damir
&gt; Sudarevic

[Wikipedia&#39;s Data Warehouse article](http://en.wikipedia.org/wiki/Data_Warehouse) tells:  

&gt; &quot;The normalized approach [vs. dimensional one by Ralph Kimball], also
&gt; called the **3NF model** (Third Normal Form) whose supporters are
&gt; referred to as “Inmonites”, believe in Bill Inmon&#39;s approach in which
&gt; it is stated that the data warehouse should be modeled using an E-R
&gt; model/normalized model.&quot;

It looks like the normalized data warehousing approach (by Bill Inmon) is perceived as not exceeding 3NF (?)

I just want to understand what is the origin of the myth (or ubiquitous axiomatic belief) that data warehousing/OLAP is synonym of denormalization?  

Damir Sudarevic answered that they are well-paved approach. Let me return to the question: Why is denormalization believed to facilitate reading?   


  [1]: https://stackoverflow.com/questions/4375192/performance-of-different-aproaches-to-time-based-data/4390401#4390401
  [2]: https://stackoverflow.com/questions/4264947/what-is-best-practice-for-representing-time-intervals-in-a-data-warehouse/4290190#4290190

Should OLAP databases be denormalized for read performance?

I am having trouble trying to pass an extra variable in the url to my WordPress installation. 

For example `/news?c=123`

For some reason, it works only on the website root `www.example.com?c=123` but it does not work if the url contains any more information `www.example.com/news?c=123`. I have the following code in my functions.php file in the theme directory.

    if (isset($_GET[&#39;c&#39;])) 
    {
      setcookie(&quot;cCookie&quot;, $_GET[&#39;c&#39;]); 
    }

    if (isset($_SERVER[&#39;HTTP_REFERER&#39;]))
    {
      setcookie(&quot;rCookie&quot;, $_SERVER[&#39;HTTP_REFERER&#39;]);
    }

Any Ideas?

How to pass extra variables in URL with WordPress

What are the WordPress alternatives for Ruby on Rails? How do they compare to WordPress?

What are the WordPress alternatives for Ruby on Rails?

What PHP code can be used to retrieve the current page name in a WordPress theme?

All the solutions I have seen so far:  
* `the_title()`  
* `get_page()-&gt;post_name`  
* `get_post()`  
* etc.  

But these don&#39;t work for a page that contains post entries. They will all return the name of the latest blog entry.

Stated another way, assume that you have a page created in WordPress with the name &quot;My News&quot;. This page is set as the &quot;post page&quot;. Add a couple of posts to the page.
Now, what API can be used to retrieve the string &quot;my-news&quot; instead of the name of the latest post?

&lt;hr/&gt;

I&#39;ve found the following variable which seems to work.

    $wp_query-&gt;queried_object-&gt;post_name

This is actually the URL friendly version of the page name (slug), which is what I was looking for too. This was tested with the default template ([Twenty&amp;nbsp;Ten][1]). I&#39;m really not sure why the two variables given below do not work on my site. Thanks to [*keatch* for the `print_r()` tip][2].

Now, why is this information hidden so deep down?

  [1]: https://wordpress.org/themes/twentyten/
  [2]: https://stackoverflow.com/questions/4837006/how-can-i-get-the-current-page-name-in-wordpress/4837579#4837579


How can I get the current page name in WordPress?

Is there a way to change the child `&lt;ul class=&quot;sub-menu&quot;&gt;` generated by WordPress itself to a custom class name?

I know the parent `&lt;ul&gt;` you can remove or change the name with `&#39;menu_class&#39; =&gt; &#39;newname&#39;`.


I couldn&#39;t find the answer. Itried `&#39;submenu_class&#39; =&gt; &#39;customname&#39;`. It seems logic to me, but obviously that is no the right one.


any ideas?

wp_nav_menu change sub-menu class name?

I need to find the latest post for each author and then group the results so I only a single latest post for each author.


    SELECT wp_posts.* FROM wp_posts
			WHERE wp_posts.post_status=&#39;publish&#39;
			AND wp_posts.post_type=&#39;post&#39;
			GROUP BY wp_posts.post_author			
			ORDER BY wp_posts.post_date DESC


This is correctly grouping the output so I only get one post per author, but it is ordering the results after they have been grouped and not before they have been selected.

Content Type	Original Author	Original Content on Stackoverflow
Question	John Connor	View Question on Stackoverflow
Solution 1 - Mysql	Nican	View Answer on Stackoverflow
Solution 2 - Mysql	tylerl	View Answer on Stackoverflow
Solution 3 - Mysql	Arun Killu	View Answer on Stackoverflow
Solution 4 - Mysql	Nedudi	View Answer on Stackoverflow
Solution 5 - Mysql	RasoolLotfi	View Answer on Stackoverflow
Solution 6 - Mysql	Dmitri	View Answer on Stackoverflow
Solution 7 - Mysql	Siraj Ali	View Answer on Stackoverflow
Solution 8 - Mysql	Richard Tyler Miles	View Answer on Stackoverflow

Table is marked as crashed and should be repaired

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Solution 5 - Mysql

Solution 6 - Mysql

Solution 7 - Mysql

Solution 8 - Mysql

'find -exec' a shell function in Linux

How do I contribute to other's code in GitHub?

Attributions