More Information about SQL Database

[articles2u]

I will want to know more about SQL database. Total number of entries permitted to each SQL table. It is possible to transfer SQL database to one server to another server (web hosting company). It is possible to reduce size of database (deleting some of pending articles). Please good replay.

 

[Peter]

Yes you can transfer databases to other hosts as long as they use the same database engine (ie mysql, mssql etc).

If you are using phpmyadmin to backup your database you in the export area you can choose to download it compressed which should reduce the download size dramatically.

Regarding whether the actual database could be made smaller really depends on your content in the database and what you no longer need.

The maximum amount of data that you can have in a table depend on a few things such as:-

Th processing power and ram available on the server
The storage space on the server
The field type used for your index field

 

[monaco]

All database servers have backup/restore functionality. But yes, they have to be the same with some exceptions. MySQL for instance can export it's backups at MSSQL or ORACLE compatible SQL.

The max amount of data also depends on licensing in some cases. MSSQL and ORACLE have space limitations (in the GB range, granted) unless you buy the most expensive versions which support clustering and SAN's and all that fun stuff.

 

[Peter]

All database servers have backup/restore functionality. But yes, they have to be the same with some exceptions. MySQL for instance can export it's backups at MSSQL or ORACLE compatible SQL.

The problem isnt just the storage of the data it is also the SQL used to retrieve it.

If you transfer to another engine, even if you change for example to the native mssql mysql functions it may still not work as you may for example be using functions within the sql that act differently in another engine.

 

[monaco]

The problem isnt just the storage of the data it is also the SQL used to retrieve it.

If you transfer to another engine, even if you change for example to the native mssql mysql functions it may still not work as you may for example be using functions within the sql that act differently in another engine.

Good point. I didn't think about stored procedures and functions in that one.

 

[articles2u]

Maximum Size allowed (per database) for uploading database to another server.

 

[seanboy]

I will want to know more about SQL database. Total number of entries permitted to each SQL table. It is possible to transfer SQL database to one server to another server (web hosting company). It is possible to reduce size of database (deleting some of pending articles). Please good replay.

http://dev.mysql.com/doc/