dumping INDEX's

[Greg Brant]

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

[steve]

"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 Brant]

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

[Greg Brant]

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

[steve]

"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

[Greg Brant]

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

[steve]

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