470,586 Members | 1,272 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,586 developers. It's quick & easy.

dumping INDEX's

Hi,

how can i backup a table / entire DB and get the index's as well as the data
/ create table's etc

cheers

Greg
Jul 20 '05 #1
6 1757
"Greg Brant" wrote:
Hi,

how can i backup a table / entire DB and get the index’s as well
as the data
/ create table’s etc

cheers

Greg


Use phpmyadmin, and then use export in that application.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-dumpin...ict140584.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=470434
Jul 20 '05 #2
yeah i tried that but it doesnt seem to have the indexes?

do all versions support this or is it a new feature?

"steve" <Us************@dbForumz.com> wrote in message
news:41********@news.athenanews.com...
"Greg Brant" wrote:
> Hi,
>
> how can i backup a table / entire DB and get the index's as well
> as the data
> / create table's etc
>
> cheers
>
> Greg


Use phpmyadmin, and then use export in that application.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-dumpin...ict140584.html
Visit Topic URL to contact author (reg. req'd). Report abuse:

http://www.dbForumz.com/eform.php?p=470434
Jul 20 '05 #3
btw,

the server is running
Welcome to phpMyAdmin 2.5.6
MySQL 3.23.56

"steve" <Us************@dbForumz.com> wrote in message
news:41********@news.athenanews.com...
"Greg Brant" wrote:
> Hi,
>
> how can i backup a table / entire DB and get the index's as well
> as the data
> / create table's etc
>
> cheers
>
> Greg


Use phpmyadmin, and then use export in that application.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-dumpin...ict140584.html
Visit Topic URL to contact author (reg. req'd). Report abuse:

http://www.dbForumz.com/eform.php?p=470434
Jul 20 '05 #4
"Greg Brant" wrote:
btw,

the server is running
Welcome to phpMyAdmin 2.5.6
MySQL 3.23.56

"steve" <Us************@dbForumz.com> wrote in message
news:41********@news.athenanews.com...
"Greg Brant" wrote:
> Hi,
>
> how can i backup a table / entire DB and get the index’s as well > as the data
> / create table’s etc
>
> cheers
>
> Greg


Use phpmyadmin, and then use export in that application.

--
http://www.dbForumz.com/ This article was posted by

author’s request
Articles individually checked for conformance to usenet standards
Topic URL:

http://www.dbForumz.com/mySQL-dumpin...ict140584.html
Visit Topic URL to contact author (reg. req’d). Report

abuse:
http://www.dbForumz.com/eform.php?p=470434


Greg, using phpmyadmin > export, you can save the table structure,
data, or both. The table structure would have the indexes included.
You don’t need to do anything more to save indexes.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-dumpin...ict140584.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=470893
Jul 20 '05 #5
got ya, lol. was looking in the sql dump and not seeing it.

Doh

cheers ;)
"steve" <Us************@dbForumz.com> wrote in message
news:41**********@news.athenanews.com...
"Greg Brant" wrote:
> btw,
>
> the server is running
> Welcome to phpMyAdmin 2.5.6
> MySQL 3.23.56
>
>
>
> "steve" <Us************@dbForumz.com> wrote in message
> news:41********@news.athenanews.com...
> > "Greg Brant" wrote:
> > > Hi,
> > >
> > > how can i backup a table / entire DB and get the

> index's as well
> > > as the data
> > > / create table's etc
> > >
> > > cheers
> > >
> > > Greg
> >
> > Use phpmyadmin, and then use export in that application.
> >
> > --
> > http://www.dbForumz.com/ This article was posted by

> author's request
> > Articles individually checked for conformance to usenet standards
> > Topic URL:

> http://www.dbForumz.com/mySQL-dumpin...ict140584.html
> > Visit Topic URL to contact author (reg. req'd). Report

> abuse:
> http://www.dbForumz.com/eform.php?p=470434


Greg, using phpmyadmin > export, you can save the table structure,
data, or both. The table structure would have the indexes included.
You don't need to do anything more to save indexes.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-dumpin...ict140584.html
Visit Topic URL to contact author (reg. req'd). Report abuse:

http://www.dbForumz.com/eform.php?p=470893
Jul 20 '05 #6
got ya, lol. was looking in the sql dump and not seeing it.

Doh

cheers
"steve" <Us************@dbForumz.com> wrote in message
news:41**********@news.athenanews.com...
*> "Greg Brant" wrote:
**> > btw,
**> >
**> > the server is running
**> > Welcome to phpMyAdmin 2.5.6
**> > MySQL 3.23.56
**> >
**> >
**> >
**> > "steve" <Us************@dbForumz.com> wrote in message
**> > news:41********@news.athenanews.com...
***> > > "Greg Brant" wrote:
***> > > > Hi,
***> > > >
***> > > > how can i backup a table / entire DB and get the
**> > index’s as well
***> > > > as the data
***> > > > / create table’s etc
***> > > >
***> > > > cheers
***> > > >
***> > > > Greg
***> > >
***> > > Use phpmyadmin, and then use export in that application.
***> > >
***> > > --
***> > > http://www.dbForumz.com/ This article was posted by
**> > author’s request
***> > > Articles individually checked for conformance to usenet
standards
***> > > Topic URL:
**> > http://www.dbForumz.com/mySQL-dumpin...ict140584.html
***> > > Visit Topic URL to contact author (reg. req’d). Report
**> > abuse:
**> > http://www.dbForumz.com/eform.php?p=470434
*>
*> Greg, using phpmyadmin > export, you can save the table structure,
*> data, or both. The table structure would have the indexes
included.
*> You don’t need to do anything more to save indexes.
*>
*> --
*> http://www.dbForumz.com/ This article was posted by author’s
request
*> Articles individually checked for conformance to usenet standards
*> Topic URL:
http://www.dbForumz.com/mySQL-dumpin...ict140584.html
*> Visit Topic URL to contact author (reg. req’d). Report abuse:
http://www.dbForumz.com/eform.php?p=470893
Glad it worked.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-dumpin...ict140584.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=471196
Jul 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by kamal | last post: by
3 posts views Thread by kerri | last post: by
6 posts views Thread by Greg Brant | last post: by
10 posts views Thread by ken | last post: by
3 posts views Thread by noleander | last post: by
13 posts views Thread by nick | last post: by
3 posts views Thread by Brian.Abernathy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.