Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC Repairing mysql database from command line

Have Programming Question? Ask it here!
 
 
 


Deepak Kumar
Repairing mysql database from command line
1 Answer(s)      3 years and 4 months ago
Posted in : JDBC


Hi,

Can anyone tell me the process for repairing mysql database from command line?

Thanks


Advertisement
View Answers

April 12, 2011 at 4:47 PM


Hi,

There are many ways you can repair your MySQL database and tables in it.

The easiest method of Repairing mysql database from command line is to use the mysqlcheck command from command line.

Command

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

Above command will find and repair the errors. It will also optimize the database for better performance.

Thanks



Related Tutorials/Questions & Answers:
Repairing mysql database from command line
Repairing mysql database from command line  Hi, Can anyone tell me the process for repairing mysql database from command line? Thanks
How to Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database ?
How to Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database ?  Import mysql database command line, Import MySQL...://www.phpzag.com/import-mysql-database-command-line-import-mysql-dumpfile-sql-datafile
Advertisements
Help on mySQL 5 command line - SQL
Help on mySQL 5 command line  Dear Sir, I had created a table for mySQL 5 called dictionary as shown below: mysql> select * from dictionary... | +----+------+-------------------------? I want to use the command SELECT WORD, MIN(num_of_searches
help on mySQL 5 command Line - SQL
help on mySQL 5 command Line  Dear Sir, Sorry for my mistake, please ignore the first post of my question I had created a table for mySQL 5 called dictionary as shown below: mysql> select * from dictionary
How to run PHP Script from the command line ?
How to run PHP Script from the command line ?  Running PHP Script from the command line   Actually it is very simple to run php script command line. Except there are a few things that are different, for example
Java memory options from command line
Java memory options from command line  Hi, How to use java memory options from command line? Thanks   Hi, Here is the example code: java -Xms1056m -Xmx1056m MyProgram Thanks
How to invoke method of a library from command line
How to invoke method of a library from command line  Suppose there are two methods in a libray and you have to invoke one of the method from that library directly from the command prompt. How will you do
How To Read String From Command Line In Java
How To Read String From Command Line In Java In this section we will discuss... giving from the command line. Command line arguments are passed... demonstrates that how to take input from command line. Here in this example we
Compiling and Running Java program from command line
Compiling and Running Java program from command line - Video tutorial... of compiling and running java program from command line. We have also video... the process of compiling and running the Java program from command prompt
Java I/O From the Command Line
Java I/O From the Command Line In this section we will learn about the I/O from the command line in Java. Several times you can see that the programs runs after taking the input from the command line. Java also supports for the command
line chart from database in jsp
line chart from database in jsp  how can i create line chart from database in jsp code
How to Check Markup in PHP File from Command Line
How to Check Markup in PHP File from Command Line  Check Markup in PHP File from Command Line   PHP has a feature that allowed you to check... try this: http://www.phpzag.com/check-markup-in-php-file-from-command-line
How to Checking Syntax Error in PHP from Command Line
How to Checking Syntax Error in PHP from Command Line  Checking Syntax Error in PHP from Command Line   PHP allows you to check your script... check this: http://www.phpzag.com/checking-syntax-error-in-php-from-command-line
Java Command Line Input
Java Command Line Input  How to get input from command line in java ?   Hi please Find the code for inputting data from the command line System.out.println("Please Input A Number"); BufferedReader br
Command line arguments
Command line arguments  Please explain me what is the use of "command line arguments" and why we need to use
Compiling package in command line
package using command line. For Eg: When i compile following command, c:>set...Compiling package in command line  Hi friends, i am totally new... as an internal or external command, operable program or batch file. please help me
character as command line arguments
character as command line arguments  public class testing { public static void main(String args[]) { char a; a=args[0]; System.out.println("character is:"+a); } } what will be the above program output
COMMAND LINE ARGUMENTS
COMMAND LINE ARGUMENTS  JAVA PROGRAM TO ACCEPT 5 COMMAND LINE ARGUMENTS AND FIND THE SUM OF THAT FIVE.ALSO FIND OUT LARGEST AMONG THAT 5   Hi Friend, Try the following code: import java.util.*; class
How To Read Integer From Command Line In Java
How To Read Integer From Command Line In Java In this section we will discuss about how an integer can be read through the command line. In Java all... value from the command line. In this example I have created a class named
How To Unblock IP address from command line in CSF Firewall ââ?¬â?? Linux Server?
How To Unblock IP address from command line in CSF Firewall ΓΆβ?¬β?? Linux Server?  Hi, How To Unblock IP address from command line in CSF Firewall... /etc/csf/csf.deny using vi editor. Command is: vi /etc/csf/csf.deny Remove
Passing argument at command line using Core Java
How to pass Command Line Argument using Core Java Description : This example demonstrate how value accepted from the command line. All argument need to placed at the command line at the time of executing your program.  class
What is command line argument in Java
of arguments from the command line. Arguments are passed as a string array...What is command line argument in Java  What is command line argument... example of command line argument program in Java?? It will be really helpful
Command Line Arguments in Java Program
directly from the command line. The user can enter command-line arguments when invoking the application. When running the java program from java command... Command Line Arguments in Java Program   
Retriving data from MYSQL without line break using java
Retriving data from MYSQL without line break using java  get data without line breaking from mysql table (i.e data stored as mediumtext )using java
Command line arguments
Java application can accept any number of arguments directly from the command line. The user can enter command-line arguments when invoking the application. When running the java program from java command, the arguments are provided
command line arguments - Java Beginners
command line arguments  how can i findout the minimum and maximum no's at the command prompt if i give some values?????????  hi friend... at the command prompt and then calculate the max and min numbers from them
retrieve data from mysql database
retrieve data from mysql database  hi am not familiar in php.....even... selected value on combobox which is to be retrieve the relevant data from mysql database using php.... below my code is that.. <html> <head>
Command Line Arguments in Java
Command Line Arguments in Java The ongoing Java application can accept any number of arguments from the command line but it is command line argument, which.... Suppose program named CmndLineArguments that accept command line arguments
Java Command Line Argument Example
for the application will be given from the command line. In this example we...Java Command Line Argument Example In this section we will read about how... provide the input using command line and the application produce the required output
Data retrieve from mysql database
Data retrieve from mysql database  Hi sir, please give some example of jsp code for retrieving mysql database values in multiple dropdown list... from the dropdown, related data will get displayed on the textboxes. Here we have
Java Generic program with command line argument
Java Generic program with command line argument  Implement Generic to perform arithmetic evaluation using command line argument by using Java
Command line argument in java
Command line argument in java. In this section we are going to discuss about command line argument in java. Command line argument allow a user to pass... user to pass any number of  argument to the command line. When running
Passing Command Line Arguments
pass values on command line argument . We are taking a sequence of character from command line at run time. Store these strings into an array... Passing Command Line Arguments     
execute a PHP script using command line
script using command line?   Hi friends, Just run the PHP CLI (Command Line Interface) program and provide the PHP script file name as the command line... interface, it may not execute properly in command line environment. Thanks
Java program to get the Command Line Arguments
Java program to get the Command Line Arguments... program we can use the string array variable args for holding command line...; Getting command line arguments -- Argument [1] is = Amit Argument
how to pass command line arguments in ant
how to pass command line arguments in ant  How to pass runtime values ie commandline arguments to a program written in java using ant tool
Printing Command Line arguments in JRuby
we will discuss about printing command line arguments in JRuby program. We can also take arguments from the command line into our JRuby program. ... Printing Command Line arguments in JRuby
Mysql Like Command
Mysql Like Command       Mysql Like Command is used for retrieving the records from a table... with Example The Tutorial illustrate an example from 'Mysql Like Command'. To grasp
Mysql Like Command
Mysql Like Command       Mysql Like Command is used for retrieving the records from.... Understand with Example The Tutorial illustrate an example from 'Mysql Like
MySQL Average Command
MySQL Average Command This example illustrates how to execute the Average command in MySQL. In this example we create a select query to find the average...; Output   select AVG(lastAccess) from emp
How to access (MySQL)database from J2ME?
How to access (MySQL)database from J2ME?  I am new to J2ME. I am using NetBeans. Can anyone help me? How to access (MySQL)database from J2ME? ( I search a lot I found that there is need to access database through servlet
retrieve data from mysql database and store it in a variable ?
retrieve data from mysql database and store it in a variable ?  sir... that retrieve the integer values from the database and stored in the integer... which is stored in mysql. so to apply some arithmetic operation on it we have
Command Line Standard Error In Java
Command Line Standard Error In Java In this section we will discuss about the Command Line Java IO Standard Error. System.out and System.err both are for Standard output but, System.err separates the error output. System.err
Command Line Standard Output In Java
Command Line Standard Output In Java In this section we will discuss about the Command Line Java IO Standard Output. Standard streams, feature of various O/S, are written through standard output in Java. Standard streams can
MySql Databse query to fetch results from database
MySql Databse query to fetch results from database  Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from
Command Line Standard Input In Java
Command Line Standard Input In Java In this section we will discuss about the Java IO Standard Input through Command Line. Standard streams, feature... the command line interpreter. Java provides System.in to access the Standard Input
problem in selecting second arraylist from mysql database
problem in selecting second arraylist from mysql database  Hi... in mysql database. In the below program , i have hard-coded that second list, but i want second list to be dynamic from database. Please, help me out. Thank
How can I execute a PHP script using command line?
How can I execute a PHP script using command line?  How can I execute a PHP script using command line
sending data to google chart api from mysql database using java
sending data to google chart api from mysql database using java  how to send data from mysql database to google chart api using java
please tell me about command line arguments in java?
please tell me about command line arguments in java?  please tell me about command line arguments in java?   Hi Friend, The command-line... take any number of command-line arguments which may be necessary for the program
 

 

 

DMCA.com