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 5 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:
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
Advertisements
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
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
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
Mysql Update command
Mysql Update       Mysql Update Mysql Update is used to modify the table...; MySQL Replace MySQL Replace function finds and replaces
Create Line Graph using database values
retrieved from the database. In this section, you will learn how to create a x-y line graph by retrieving the values from the database. Here is the code: import...Create Line Graph using database values JFreeChart library has made
How to read data from txt file and save to database MySql - Java Beginners
How to read data from txt file and save to database MySql  Please... save to database from JButton.Please give me a tutorial and source code...[]) { try{ // Open the file that is the first // command line parameter
MySql database - SQL
to retrieve the data from Ms-access then you create a database , table and create a connection with this. Then you retrieve the data from the database. Thanks...MySql database  hello sir, i am trying to write a code which should
How to read a line from a doc file
How to read a line from a doc file  How to read a line from a doc file   Hi Friend, To run the following code, you need to download POI library. import java.io.*; import org.apache.poi.hwpf.HWPFDocument; import
Using MYSQL Database with JSP & Servlets.
current command   quit (\q)  Quit mysql  ... Using MYSQL Database with JSP & Servlets.  ... acceres the MYSQL database. Here I am using MYSQL & tomcat server
Use of yum install linux mysql php command on Linux box
following command: yum install mysql-server mysql Here is the output of the command...-width: 1px; border-bottom: 1px solid #C0C0C0; } Install PHP, MySQL and Apache server using yum command. In this section you will see the process
Read Specific Line from file Using Java
Read Specific Line from file Using Java Here we are going to read a specific line from the text file. For this we have created a for loop to read lines 1 to 10 from the text file. If the loop reached fifth line, the br.readLine() method
Connecting to MySQL database and retrieving and displaying data in JSP page
Connecting to MySQL database and retrieving and displaying data in JSP page...; This tutorial shows you how to connect to MySQL database and retrieve the data from the database. In this example we will use tomcat version 4.0.3 to run our
connect to the database from JSP
connect to the database from JSP  How do you connect to the database from JSP?   A Connection to a database can be established from a jsp page by writing the code to establish a connection using a jsp scriptlets
Backing Up and Restoring A MySQL Database
to restore the accounts database from accounts.sql backup file. mysql - u admin...; This tutorial explains the how to backup and restore the MySQL Database. Databases...; backup data can be used to restore the Database. Backing Up MySQL Database MySQL
How to extract a specific line from a text file? - IoC
How to extract a specific line from a text file?  Hi all, i'm trying to write a code that return a specific line from a text file. so my first..., it's working fine and it's from Roseindia tutorial. But now, i want to extract the line N
selecting data from database
selecting data from database  how to select data from database using Dao in struts   Hi, You have to load the data from database using hibernate and send the data in a Java file object to jsp page. Please read at http
Image retrieval from mysql - JSP-Servlet
Image retrieval from mysql  Hai friends, I used the following code to insert image into mysql db. Db data type is blob. Database connection codings are in different file which is to be included
Display Blob(Image) from Mysql table using JSP
Display Blob(Image) from Mysql table using JSP In this section, we will display blob data(image) from Mysql database table using JSP code. A Blob stores a binary large object in the database table's row. Blob object contains
binding jComboBox to mysql database - Swing AWT
binding jComboBox to mysql database  I am using netbeans 6.5 How to populate jComboBox with data of specific column of mysql database table? I... = null; String url = "jdbc:mysql://localhost:3306/"; String db
retriving image from database - JSP-Servlet
retriving image from database  how to retrive image from mysql database by using servlet programming  Hi Friend, Please visit the following link: http://www.roseindia.net/servlets/retreiveimage.shtml Thanks
delete data from database - SQL
delete data from database  HOw to delete specific data from table> I want to delete one record from database. Thnx  Hi friend, -------------------------------------------- Visit for more information
php import data from excel to mysql
php import data from excel to mysql  php import data from excel to mysql
Accept command in Oracle
Accept command in Oracle In this section we will see how to use the Accept command in SQL Plus. The ACCEPT command in SQL Plus is used to take the input from... is retrieved from database. You can use SQL Plus to generate many types
How to Restore The Lossed data in MYSQL database after the System is formatted
How to Restore The Lossed data in MYSQL database after the System is formatted  How to Restore The Lossed data in MYSQL database after the System is formatted
How can we create a database using PHP and mysql?
How can we create a database using PHP and mysql?  How can we create a database using PHP and mysql
Get date data type from table
GET DATE DATA TYPE FROM TABLE In this example , we will get "Date" data type from a table of "Mysql" database and it also display... = "jdbc:mysql://192.168.10.13:3306/";      String dbName = "ankdb
In this section you will learn how to rename MySQL database.
the data into accounts2 database using following command: mysql - u root -p root...How to rename MySQL database? In this section we will learn the safest method to rename MySQL Database. The following statement was added in the MySQL
How to make a connection from javaME with MySQL - SQL
How to make a connection from javaME with MySQL  Hi i`m a final year student from one of university from malaysia, I have a problem about my final... and MySQL. I really hoping someone could help me on my final year project
MySQL Alter Tutorial, Database MySQL MySQL Crash Tutorial Tutorial
the records from table in the database.    MySQL PHP... of a column in a table.    Mysql Alter Command Mysql Alter Command define the list of Command used for removing 'Primary
store and retrive image from database - JDBC
()); } } } For retrieve image from database visit to : http...store and retrive image from database  how to store and retrive an image in database using java?  Hi friend, Code for store image
pls provide steps to connect mysql database in flex - XML
pls provide steps to connect mysql database in flex  hi, pls provide steps to connect mysql database in flex.pls i am trying from last week still it was not connected .pls provide the step by step procedure.i am looking
How to make a connection from javaME with MySQL - SQL
How to make a connection from javaME with MySQL  Hi i`m a final year student from one of university from malaysia, I have a problem about my final... and MySQL. I really hoping someone could help me on my final year project
Search data from database - Java Beginners
to user name. (means search all field from database and display using... in the previous page, then according to that, use the sql command as delete * from...Search data from database  Hi Deepak, This is not correct code
How to create database in mysql using ANT build - Ant
How to create database in mysql using ANT build  Hello , can anybody tell me how to create a database in mysql using ant build.Please tell... in build.xml to create a database: Create Database roseindia For more
form text box connection with mysql database feild - JDBC
form text box connection with mysql database feild  Respected Sir, What is the coding to connect a form text box field with mysql database table field will you explain me with simple example.. thanking you.. 
Connecting to Database from a hyperlink in JSP - JSP-Servlet
Connecting to Database from a hyperlink in JSP  How can I connect to database by clicking on a hyperlink in a JSP Page.Can you please give me sample... which is connect to database using jdbc database
pbml in inserting selected item from combobox into mysql - XML
pbml in inserting selected item from combobox into mysql  hi, i have to insert the selected item from combobox into MYSQL database.pls provide... another doubt when i entered the input from flex .it is storing in mysql database.but
Compute command
Compute command  hello, What is compute command?   hii, samar Compute command control computations on subsets created by the BREAK command
Create a counter in mySQL 5 database through Java - SQL
Create a counter in mySQL 5 database through Java  Dear Editor... question regarding Java & mySQL 5 database.... ============================================================== This is an example of mySQL5 database as shown above. For example "Bee
inserting image in mysql database using browse button in servlets
inserting image in mysql database using browse button in servlets  Hi,I want to insert a image in mysql database using browse button. and, i want to display all inserted images in a form from there i want to download the image
how can i create a mysql database to connect to this code - JDBC
how can i create a mysql database to connect to this code  i need help creating a mysql database for this code. code is import java.awt...."); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register
how can i create a mysql database to connect to this code - JDBC
how can i create a mysql database to connect to this code  i need help creating a mysql database for this code. code is import java.awt...."); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register
Setting up the database in PHP
will tell you how to create a database and tables in MySQL and also how... a database to insert the information into and read it from. I think your mind raises... is the procedure to construct database. Database Construction The best thing about MySQL
Using javabeans to connect mySQL database on a jsp page - JSP-Interview Questions
Using javabeans to connect mySQL database on a jsp page  Hi, Am doing my project and I don't know how to connect a jsp page to a mySQl database...; Connecting a JSP page to MYSQL Database using JavaBean File Name: beancode.java
data are not display in JSP from database - JSP-Servlet
data are not display in JSP from database   i want to finding some data through a SQL query from SQL server database to a JSP page based on some.... one.jsp value of 'school' request parameter are comming from the link
make chart or graph from database - Java Beginners
make chart or graph from database  d, I want to ask about how to make a chart or graph. First i have Table name= "customer" and field =(cust_id,nm_id,date_cust) I want to view in date,know who's to my customer and how many
Welcome to the MySQL Tutorials
the data from MySQL database in JSP page.  ...;    The MySQL database server is most popular database.... In this tutorial you will learn how to use MySQL database server
Advertisements
 

 

 

DMCA.com