Home / server / Questions

Questions[export](server)

Martin Hope
grape
Asked: 2011-08-12 14:55:38 +0800 CST
  • 47
  1. I've got a 30K row table
  2. When I run a long, 50-line query on that table, a GROUP function reduces the number of rows to 7K
  3. I want to export the grouped 7K rows as a new table, or save them as a CSV

When I attempt to export, instead of getting the grouped 7K rows, I get the old, pre-query 30K rows. What am I doing wrong, and what should I be doing?

NOTE: I'm not a coder, so I'd really appreciate a solution that just used the phpMyAdmin GUI.

mysql csv export phpmyadmin
Martin Hope
Talis
Asked: 2010-11-12 04:58:07 +0800 CST
  • 20

'exportfs -r' returns me this error when I'm trying to export /home/user/share (ext4):

exportfs: Warning: /home/user/share does not support NFS export.

/etc/exports:

/home/user/share 192.168.1.3 (rw,no_subtree_check)

The system is Ubuntu 10.04 with nfs-kernel-server package. Any ideas why this is happening? Is it because of ext4?

nfs ext4 export
Martin Hope
soopadoubled
Asked: 2010-05-18 04:37:43 +0800 CST
  • 11

I'm having an issue, where for ease of use, I'd like to be able to format a command line MySQL dump so that each row of a given table is on a new line when using the --extended-insert option.

Usually when using --extended-insert, every row of a given table is outputted on one line, and as far as I am aware there's no way to change this, other than post-processing the dump with perl or such like.

The format I'm looking for is:

-- 
-- Dumping data for table `ww_tbCountry`
-- 

INSERT INTO `ww_tbCountry` (`iCountryId_PK`, `vCountryName`, `vShortName`, `iSortFlag`, `fTax`, `vCountryCode`, `vSageTaxCode`) VALUES (22, 'Albania', 'AL', 1, 0.00, '8', 'T9'),
(33, 'Austria', 'AT', 1, 15.00, '40', 'T9'),
(40, 'Belarus', 'BY', 1, 0.00, '112', 'T9'),
(41, 'Belgium', 'BE', 1, 15.00, '56', 'T9'),
(51, 'Bulgaria', 'BG', 1, 15.00, '100', 'T9'

However, when I dump a database using Phpmyadmin, using --extended-insert, each row is dumped on a new line (as shown by the example above). I've gone through Phpmyadmin and can't find any documentation that would explain this.

Is anyone able to shed any light on this?

mysql export
Martin Hope
romandas
Asked: 2009-07-25 07:14:19 +0800 CST
  • 9

I need to dump all the Group Policies within Active Directory to review offline at a later date. Is there a way I can easily export all the Group Policies to text or some other easily-parseable format?

Edit: Will these tools work from a computer that is not part of the domain? I have domain credentials, but my work laptop isn't necessarily part of the domain I need to review.

group-policy active-directory text export
Martin Hope
Agvorth
Asked: 2009-07-07 13:54:40 +0800 CST
  • 40

I'm setting up up a new MySQL server and I'd like to give it the same set of usernames, allowed hosts, and passwords as an existing server (which is going away).

Would it work to just do a dump of the users table and then load it on the new server?

Is there a better way than that?

mysql user-permissions user-accounts export