Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
MySQL OUTFILE exporting data
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- MySQL OUTFILE exporting data
MySQL OUTFILE exporting data
21-08-2007 12:28 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I'm quite new to the MySQL stuff and have searched the net for an answer to exporting (backup) all the data from a table.
I have tried the command localy (localhost) and it works fine but when i use the PlusMySQLAdmin interface it returns an error. Can someone help please?
Heres the command I'm using:
SELECT * INTO OUTFILE 'C:/backup.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM myTable;
I have tried the command localy (localhost) and it works fine but when i use the PlusMySQLAdmin interface it returns an error. Can someone help please?
Heres the command I'm using:
SELECT * INTO OUTFILE 'C:/backup.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM myTable;
Message 1 of 4
(2,492 Views)
3 REPLIES 3
Re: MySQL OUTFILE exporting data
21-08-2007 1:24 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Quote I have tried the command localy (localhost) and it works fine
Do you mean your own MySQL installation, if so is it version 4 like Plusnet?
Why don't you use the MySQL Dump program instead, it seems to be what most people use?
Message 2 of 4
(886 Views)
Re: MySQL OUTFILE exporting data
21-08-2007 1:27 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Like i explained, I'm faily new to this. Whats the MySQL dump?
Message 3 of 4
(886 Views)
Re: MySQL OUTFILE exporting data
21-08-2007 1:36 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I think I found it. Sorry had a blonde moment ???.
I've been going about it all the wrong way. I've been using command lines to develop my databases and should have realised that the wheel has already been invented....
Thanks for kicking my brain into gear.
I've been going about it all the wrong way. I've been using command lines to develop my databases and should have realised that the wheel has already been invented....
Thanks for kicking my brain into gear.
Message 4 of 4
(886 Views)
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- MySQL OUTFILE exporting data