How to create tablespace in Mysql and assign specified table created to the tablespace created?

Posted on 2010-01-03
Last Modified: 2012-05-08
How to create tablespace in Mysql and assign specified table created to the tablespace created?
Question by:umesh4exp
    LVL 1

    Assisted Solution

    Have you checked the MySQL documentation? If you are using MySQL 5.1, see the following:

    Author Comment

    checked but i am not able to do the same,
    please post some snippets on the same it will be greatly helpful.
    LVL 1

    Accepted Solution

    The most basic usage of a MySQL tablespace is:

    CREATE TABLESPACE my_tablespace
     add datafile 'my_tablespace_file'
     engine falcon

    CREATE TABLE `my_table`
     my_column VARCHAR(10) NOT NULL
    ) tablespace = my_tablespace;

    However if you want anything more specific you'll need to be a lot more specific in your question.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now