Go Back  HTML Forums - Free Webmaster Forums and Help Forums > WEBSITE DEVELOPMENT > Databasing
User Name:
Password:
 

Reply
Thread Tools   Display Modes
  View First Unread
 
Old 06-14-2012, 05:13 PM
  #16
CGM Findings
Novice (Level 1)
 
Join Date: Jun 2012
Posts: 2
iTrader: (0)
CGM Findings is an unknown quantity at this point
Finding the right database - MySQL

Unless I am mistaken, your upload max limitation is referenced by your php.ini file if you are using mysql apache & phpmyadmin.
The file size you are talking about is pretty enormous.
I believe if you are comparing databases, especially regarding file size you should look at or compare it (MySQL) to other large scaling db formats - not Oracle. I do know one plus is MySQL can run on different platforms and with different programming languages, such as PHP or Python, but that's another discussion.
Regarding MySQL, I do know that somewhere around the web, or in other parts - there exists mysql dbs that are up in that range, so for theoretical standpoint, as far as I know - it can do it.
As stated one way that people use is big dump.
Another way is to break up your sql dump, query or insertion into chucks. Probably the best way is by tables if you have them.
I believe there are tools that will help you add the records to build up your database.
Running same versions can be helpful.
Don't forget that usually your files are stored as .MYI .MYD .frm files usually in mysql - /data/mysql_data/
if you have these files you can always recreate the db.
For more information on managing mysql databases with outside programs, simply google "mysql tools." Or take a look at this article - http://coding.smashingmagazine.com/2...ools-round-up/ I have heard a few people say fairly good things about navicat.
Hope this helps. Help Fun!
CGM Findings is offline   Add to del.icio.us Add to del.icio.us    Can you digg it?Can you digg it? Reply With Quote
Reply
KEEP TABS
SPONSORS
 
Boxedart

 
 


 
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
  
 
 
 



 
  POSTING RULES
 
 
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Thread Tools
Display Modes

Forum Jump

 

All times are GMT -5. The time now is 06:28 PM.

   

Mascot team created by Drawshop.com | Web Hosting

Powered by vBulletin® Version 3.6.7
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

Server Monitoring by ENIACmonitor 0.01
HTMLforums.com © Big Resources, Inc. Web Design by BoxedArt.com
vRewrite 1.5 beta SEOed URLs completed by Tech Help Forum and Chalo Na.