Sun MySQL Logo

Related Topics:

Posted on Aug 28, 2008

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.

1 Answer

Anonymous

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
  • Posted on Oct 05, 2008
Anonymous
Contributor
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.

Joined: Oct 05, 2008
Answers
13
Questions
5
Helped
2717
Points
19

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.)

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
1answer

How to migrate data between two databases?

If you want to migrate data from one database to another, you can use dbForge Studio for MySQL with its wide range of data migration features https://www.devart.com/dbforge/mysql/studio/migrate-database.html
2helpful
2answers

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
1helpful
3answers

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
1helpful
2answers

'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/
0helpful
1answer

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
1helpful
5answers

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
2helpful
2answers

Rename a mysql database with phpmyadmin

Yes. In the SQL tab,

RENAME DATABASE test TO new_test ;
Aug 05, 2008 • Sun MySQL
0helpful
2answers

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?

166 views

Ask a Question

Usually answered in minutes!

Top Sun Computers & Internet Experts

Rob Hill
Rob Hill

Level 3 Expert

1480 Answers

k24674

Level 3 Expert

8093 Answers

Sean Wright
Sean Wright

Level 3 Expert

2045 Answers

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

Answer questions

Manuals & User Guides

Loading...