Linux

Ask something
Discussion Locked

How to export file?

0 helpful
3 replies

by andyngcw

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I am newbie in using Linux and I would like to know how to use e.g. SQL command or other tools in PhpAdmin to export the database file to a text or CVS format?

Please give advise.

Thanks and regards,

Andy Ng

3 replies

by jaqui

for which db engine?

open the phpmyadmin/phppgadmin in browser through fqdn ( regular browsing ) or localhost
select database
click tab to access data
select dump database
click go/select
save as box pops up
choose filename and extention.

by jaqui

that depends on the specific database server.
if you are using cpanel, you are probably taking a hosted site, not one where server in physically accessable.

if the host allows for ssh access then console is available, but they may have limited application availability via ssh/console

you may want to just code the app you want to connect to the remote db, then it will always be in sync, so all actions will be run against current data set.

if you want to back it up,
just dump it with sql inserts.
even access by m$ will read an sql query and import it, csv is not actually required.

by andyngcw

Hi,

I find there is an option in Export (to export the database) of PhpAdmin in Cpanel which allow the user to select CVS format for MS.

However, do you know what is the SQL command to export the database file to CVS in the command line?

Thanks and regards,

Andy Ng

This discussion is closed to new replies.