yordan

Nov 30 2006, 01:49 PM

QUOTE

dont worry abt ur English knowledge, ur regular posting in Astahost may help ur Writing skill.

But you should not use this kind of working. Reading words like "ur" helps nobody learn English.

Reply

BuffaloHELP

Dec 3 2006, 08:08 AM

QUOTE(Melanova @ Nov 30 2006, 07:28 PM)

So does the mysql db count against our total space?

No, the size of your database does not count towards your hosting disk space. Basically, think of database as free hosting place for your data files that is an extra add-on to your hosting pace. Therefore you can create how large or how many database you'd like as long as you are well within AstaHost Free Web Hosting, No Ads AUP and TOS.

Not bad for free hosting place, huh?

Reply

Latest Entries

yordan

Dec 3 2006, 11:09 PM

QUOTE(borlafu @ Dec 4 2006, 12:03 AM)

Are you sure? I think the size of the databese is added to your disk usage. At least it sould for security reasons...

If you look at your cpanel General account information, you will see the exhausted part of your quotas.
You will see someting like :

QUOTE

Disk usage 64.29 / 150.00 MB
SQL Disk usage 1.59 MB
Disk space available 85.71 MB

So, it seems that today the SQL disk usage is a courtesy of astahost, they kindly take it apart from our general disk usage.
So, we should not abuse, else they will change their mind!

Reply

1. mysql record capacity - 84.41 hr back. (1)
2. mysql blob capacity - 98.75 hr back. (1)
3. text database php capacity - 103.53 hr back. (1)
4. mysql database maximum record - 124.72 hr back. (1)
5. mysql database maximum capacity - 136.54 hr back. (1)
6. max long int capacity in mysql - 150.40 hr back. (1)
7. mysql max database file - 152.37 hr back. (1)
8. database capacity mysql - 153.30 hr back. (1)
9. mysql database capacity - 12.84 hr back. (5)
10. max data in mysql database - 155.58 hr back. (1)
11. how to copy huge mysql database - 155.70 hr back. (1)
12. db capacity - 157.56 hr back. (1)
13. capacity of mysql database - 164.53 hr back. (1)
14. mysql max data storage capacity - 178.54 hr back. (2)

1. Free Or Opensource Database/schema Browser? - Alternatives to TOAD or PL/SQL Developer (6)

   I was wondering if there were any alternatives to TOAD or PL/SQL Developer that allows you to browse
   through a database(s), the different schema objects, and perhaps the stored
   procedure/function/packakge editors. One thing I have tried is to the use the Data Tool Plugins set
   for my Eclipse but that brings my machine's performance to crawl. One a further note, I am
   basically looking for Windows environment, with connections to remoate databases....

2. Login System - I want to make a login system using Mysql. I am amateur in these thing (6)
3. Best Database - (13)

   What is the best free database if some one trying built a social networking website? And how to
   operate it with dreamweaver 8?...

4. Mysql Overhead - (3)

   Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size
   near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a
   press of a button but i'd like to know what happens when i optimize a table. Also when you make
   a new table you can limit the size of VARCHAR to a number, that number would be the number
   characters allowed in that column per entry. I'd like to know how the limit works for texts, is
   it in KB? or number of characters? Cuz i made a messaging system. And i remember reading s...

5. How To Understand A Database Schema - A very nice and simple tutorial (4)

   Yesterday while i'm seaching for a data model and database schema at the Library of Free Data
   Models for a new project of a friend of mine i found there this nice and simple tutorial on How to
   Understand a Database Schema . As its name says, this tutorial will help you to better understand a
   Database Schema and covers the following basics topics that every Database Schema must define:
   QUOTE Primary and Foreign Keys. One-to-Many and Many-to-Many Relationships. Inheritance.
   "Rabbit's Ears", (Recursive relationships). The Scope of this tutorial is ...

6. Navcat For MySQL - is Navcat any good? (9)

   Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
   played around with the demo. Has any one used it beore, if so please let me know if its worth
   buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
   and functionality. Regards...

7. MySQL Realtime Replication - how to replicate mysql in realtime (4)

   i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
   siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
   do realtime replication. the idea is that there are master server and slave server. both are having
   the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
   you'll never have to manually copy the database file of wasting your time to manually use the
   mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.h...

8. Some Useful Database Links. - (7)

   I thought I would take a moment to point the users here to some of the database resources available
   for reference and learning. First I will start with actually designing the database. This site by
   R937 covers the basics of database design. The author is professional database guru and a frequent
   helper at the at DB forums listed below. The Library of Free Data Models is an excellent
   resource for finding data models for projects you may have or as examples of well put together data
   models. With around 500 data models the chances are you find something at least cl...

9. MySQL Output Database Question - (18)

   I am new to MySql and have just created a database after using a script. My problem is not the
   script, but what it says about putting it into the output file. I cant figure out the right terms
   to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
   'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
   please help me out?...

10. Any Website Provide Free Host Mysql Host? - (4)

    any website provide free host mysql host? i need it because i am using 000webhost.com now but it
    only provide 2 mysql database... can i know where or how can i get more databases regards...

11. Recover Tables From A MySQL .frm File - (8)

    I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
    the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
    innodb...

12. Mysql Multiple Tables - (1)

    It is good practice to use multiple tables to sort out big amounts of data. But once you do that it
    becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command
    structure that they have added. You can select multiple tables within one sql query. Example of a
    basic sql query CODE $sql = "SELECT * FROM table WHERE row=1"; If you noticed that I selected
    all of the rows in the table. Normally you will try to not select the entire table from the database
    unless you absolutely want all of the table. I would recommend against it; just gra...

13. Login System Using A Mysql Db - How do i do this? (5)

    Hi guys, ive got a registration system that looks something like the one below: Firstname:
    Lastname: Then i have inset.php, which looks like the following: $con =
    mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect: ' .
    mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person (username, password) VALUES
    ('$_POST ','$_POST ')";if (!mysql_query($sql,$con)) { die('Error: ' .
    mysql_error()); } echo "1 record added";mysql_close($con) ?> Now my question is, how do i creat...

14. Accessing Ms Access Database From A Centralized Location? - (5)

    Hi I am a manager at a trading/wholesaling company (and have no programming background). I
    customized the Northwind sample access database to make invoices and keep accounts for my company.
    We now opening another office at a distant location. So, the order entry will be done at two
    points(we plan to use the same Access database). I am not able to figure out how to access the same
    MS Access database from two different location(as LAN can't be used). Moreover, we can't
    afford to pay huge sums to the software developers. Can intranet or uploading the database t...

15. Space Needed For Database - (10)

    Iam assuming the information in the databases i will create will be stored in the 500 MB space i
    get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the
    following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest
    present when you add/edit a row in a table. Also what are the ranges of tinyint,smallint,mediumint
    and big int...

16. Database Access On Remote Server W/jsp - (0)

    Hello: I am new to JAVA and server-side applications and have a dumb question. I have set up
    Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less
    connection. If I publish the page to a webserver and include the .MDB file will it work? I'm
    not sure exactly what needs to be packaged with my Java application to make it work. Since I
    don't have a remote server that supports .jsp I cannot really test it. I'm assuming that
    JDBC driver would be bundled with my site but not sure. Thanks!...

17. MySQL, Multiple Tables - (24)

    Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
    learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
    needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
    together? I could probably figure this out faster if someone explained and posted sample SQL code
    that shows how the two are linked together. Thanks!! F...

18. Mysql Database Entry By Excel Sheets - (2)

    Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
    mysql database. Thanks...

19. Mysql On Computer - XD (9)

    I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if
    there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i
    want and upload it when i get hosted =)...

20. MySQL - Trouble With Bulk Insert Statements - (3)

    I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste
    too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors
    but then the row is skipped so I don't know there was an error (I'm using linux and SSH).
    What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I
    can have it tell me if there where any errors all the statements are executed? Thanks for your
    help....

21. Mysql Database Management - (1)

    Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
    to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
    following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
    City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
    bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
    BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ...

22. Mysql And User File_priv - (0)

    HI, I've hit the grain while trying to import file to mysql database - I need to enable file
    permissions of the database user but this seems not possible with most of the hosting providers.
    The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
    the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
    allow privileges on table querries but you cannot grant host file privileges to the database user -
    which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen...

23. I Have An Error With My Mysql Connection - mysql connection error (7)

    ok so here's my web page... http://lacrossems.t35.org/ it only lags cause its trying to
    connect to the my sql server...i followed this guide
    http://forum.ragezone.com/showthread.php?t=387249 and when i edit my config.php to my host and
    login info i always get the error cannot connect to the database here is my config.php if you can
    help me CODE $host = 'CENSORED';                // my host $host =
    'righto';       // my database username $host = 'CENSORED';   // my database
    password $host = 'odinms';       // my datab...

24. Mirror My MySQL Database To Another Mysql Server - (4)

    Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
    server?or create a small php script to do this? The reason is because, we all know that database is
    very improtant if we have dynamic website. I have my forum hosted and i want to automatically
    mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
    that i forgot to backup my database..also i have one central backup database. Thanks for the
    help..Im looking forward for this posibility....

25. Mysql - So Hard - Come in here if you think MySQL is soo hard! (14)

    Doesn't anybody think MySQL is so hard to code? I mean think about it, you need loads of
    databases just for one little script and you have to type things in like ;Host-Username:
    (blahblah) ;Host-Password: (blahblah) ;Host-DatabaseName: (blahblah) Ok, that MySQL code was
    random, and it is alot harder than that. If you have expierenced it being hard, you are free to
    post right in here, mate....

26. Mysql And Php - When trying to install Joomla (15)

    I don't know if this is the correct forum, but here is my question: I'm trying to test
    Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache,
    and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this
    error: Required Settings Check: ------------------------------------- PHP version >= 4.1.0
    Yes - zlib compression support Available - XML support Available - MySQL support
    Unavailable configuration.php Writeable Session save path Unwriteable Not ...

27. Mysql Backup With Another Address? - (4)

    I just got my site hacked!! (don't worry because it is not on astahost) Actually it is a
    wordpress blog. So I backed up my MySQL Databases with cpanel. Now when I get my hosting approved
    here at astahost, can I restore those backups? Is the change of the site address going to interfere
    with this? Is there anyway I can edit those databases to work with my new address? Please help me
    out here!...

28. Integrate Access Database Onto Intranet Site - Looking to integrate access database into my intranet site (5)

    Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
    emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access, it
    consists of multiple forms which i plan to host on an intranet website, i need to be able to add
    records directly from the form on the intranet website aswell as being able to edit/review current
    entries on forms in the database. My question is, how would i go about integrating these forms onto
    the intranet website? i plan on keeping the database and the intranet site on the same d...

29. Sun Bought Mysql - (6)

    SUN bought the swedish company MYSQL for much money, around 2million each worker got in the company,
    they did it to come in to the database market, is it a good reson to buy it?...

30. How To Connect MySQL With Flash? - Help me connect my flash Work with MySql (8)

    I know Flash and mysql but could not figure out if I could ever connect these? I want to have a
    dynamic content in my flash object that could be retrieved from the database directly without myself
    needing to update it again and again. How can I achieve this ? Do I have to install any additional
    controls or connectors to do that ? If yes any one tell me...