Question about Sun MySQL

1 Answer

Steps and definition of ReOrganizing mysql Database

Can u explain me what is meant by Re-organizing of a Mysql Database(or Any database) and what are steps included for re-organizing the DB.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 13 Answers

I can't really tell what you mean by "re-organizing" a database. Some things this could include are:

  • Creating new tables
  • Deleting unused tables
  • Changing the structure of the database's tables (adding fields, removing fields, moving fields between tables, etc.)

Posted on Oct 05, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Could not connect to MySQL


Hi;

You can start/stop the mysql service on the server by logging into the server as root from the command line interface and run the following command/s.

service mysql stop
service mysql start
service mysql restart

You can also use the following if the above does not work fine.
Fix Toolbox for MySQL
https://www.fixtoolbox.com/repairtoolformysql.html

Jul 07, 2016 | Wolfgang Schmuck MySQL

2 Answers

How to restore MySQL database Windows tool?


You can restore corrupt and delete SQL database file in few steps for MySQL Restore Toolbox. With this software you can also recover triggers, keys, indexes and table. Software support multiple MDF file recovery option. Software is supported by all Windows operating system. Get more ideas and download free trial version from -http://www.filerepairforum.com/forum/databases/databases-aa/mysql/1162-dump-mysql-database-file-is-error

May 29, 2015 | Sun MySQL

2 Answers

How to fix mysql error 1046?


For the database import, before you attempt to import the "flat" file data in, you need go to your local DB (MySQL) and create new database
After that you can import!
Also check this links:
http://www.repairtoolforsql.fixtoolbox.com/ Fix Toolbox for MySQL
http://www.sqlservercentral.com/Forums/Topic1618894-2893-1.aspx

Apr 09, 2015 | Quest Software Toad for MySQL

2 Answers

'Table does not exist' error in MySQL, although it really exists


it usually means that no table exists in the default database with the given name. In some cases, it may be that the table does exist but that you are referring to it incorrectly. Maybe your database and table names are case sensitive if they are located on a file system that has case-sensitive file names. Or perhapsall references to a given table within a query must use the same lettercase.
Use SHOW TABLES to check which tables are in the default database.
Well, if you are sure that table is exist and you write its name exactly such it should be, then I suppose something wrong with the database, it can be seriously corrupt. And in this case you need a professional help. This tool must help at any rate - Recovery Toolbox for MySQL https://mysql.recoverytoolbox.com/

Mar 11, 2015 | Oracle MySQL Enterprise Ed 1-4 Socket...

2 Answers

How to fix mySQL corrupt databases?


you should follow two steps:

Create an appropriately named database on the target machine
Load the file using the mysql command:
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
Have a look how you can restore your tut_backup.sql file to the Tutorials database.
$ mysql -u root -p Tutorials < tut_backup.sql
To restore compressed backup files you can do the following:
gunzip < [backupfile.sql.gz] ' mysql -u [uname] -p[pass] [dbname]
If you need to restore a database that already exists, you'll need to use mysqlimport
command. The syntax for mysqlimport is as follows:
mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]

Or make use of Repair Toolbox for MySQL

Demo version is here-: http://www.sql.repairtoolbox.com/

Feb 08, 2015 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

MySQL Database


THE SYSTEM REQUIRMENTS ARE
MySQL Tools
1. A SQL server : This is an engine which provides access to your databases.
2. Client programs for accessing the server : A program allows you to enter queries directly and view results
3. A client library for writing your own programs : You can write your own programs into the client library using C.
Recommended Hardware Requirements For Mysql Installation
  1. Pentium V processor
  2. 128 MB RAM
Note that MySQL can be installed on a platform with as little as 32 MB
RECOMENDED SOFTWARE TOOLS for better performance
IT is recommended to have at least 128MB memory.
You can freely download MySQL from the website http://www.mysql.com MySQL runs on many varieties of UNIX, as well as on other non-UNIX systems, such as Windows and OS/2. MySQL runs on hardware from home PCs to high-end server. MySQL can be installed on Windows XP, Windows Server 2003, Red Hat Fedora Linux, Debian Linux, and others

Sep 08, 2008 | Sun MySQL

4 Answers

Table Repair MySQL


MySQL offers Check Table syntax that checks a table or tables for errors. It works for several storage engines like MyISAM, InnoDB, & Archive. If you run this syntax then you can the cause of problem & reported tables.

If Check Table finds errors then you can repair reported tables by Repair MySQL Table syntax.

Aug 06, 2008 | Sun MySQL

2 Answers

Rename a mysql database with phpmyadmin


Yes. In the SQL tab,

RENAME DATABASE test TO new_test ;

Aug 05, 2008 | Sun MySQL

2 Answers

Mysql Report Error


An example of getting feedback from MySQL about a PHP problem -

mysql_connect("my.site.com", "username", "password")
This can also be done with this code -
die(mysql_error())

Each of the above lines will return the errors, if you have problems connecting to your MySQL database.
There are many more ways, this is just a taste.

Jul 29, 2008 | Sun MySQL

Not finding what you are looking for?
Sun MySQL Logo

Related Topics:

138 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sun Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18377 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Cosma Papouis
Cosma Papouis

Level 3 Expert

409 Answers

Are you a Sun Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...