#161  
Old 19th February 2009, 14:13
wr19026 wr19026 is offline
Senior Member
 
Join Date: Jan 2006
Posts: 172
Thanks: 7
Thanked 1 Time in 1 Post
Default

Ok thanks. Not what I had hoped for but you can't have everything I guess
Reply With Quote
Sponsored Links
  #162  
Old 21st April 2009, 14:10
esezako esezako is offline
Senior Member
 
Join Date: Dec 2008
Posts: 176
Thanks: 16
Thanked 4 Times in 3 Posts
Default

hi, the numbers of groups and users not match in my olds and news files passwd , shadow and group. What numbers should I keep?
Reply With Quote
  #163  
Old 24th May 2009, 11:59
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,262
Thanks: 78
Thanked 24 Times in 20 Posts
Default

trying to export from MySQL version 5.0.51 via
Quote:
h1550830:~/.ftplicity# mysql -h localhost -u root -pmyPass -c --add-drop-table --add-locks --all --quick --lock-tables web6db5 > /root/web6db5.sql
mysql: unknown option '-c'
as shown here: http://www.howtoforge.com/faq/6_3_en.html

can someone please explain what to use instead of this -c switch?

ok, seems the -c switch is obsolete, so I tried the replacement --skip-auto-rehash:

Quote:
h1550830:~/.ftplicity# mysql -h localhost -u root -pmyPass --skip-auto-rehash --add-drop-table --add-locks --all --quick --lock-tables web6db5 > /root/web6db5.sql
mysql: unknown option '--add-drop-table'
h1550830:~/.ftplicity#
stil no go?

Last edited by Ovidiu; 24th May 2009 at 12:05.
Reply With Quote
  #164  
Old 24th May 2009, 12:16
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,262
Thanks: 78
Thanked 24 Times in 20 Posts
Default

I tried exporting/importing via phpmyadmin as its a small DB but then I get this type of errors in every table:
Quote:
The following indexes appear to be equal and one of them should be removed: comment_author_url, comment_author_url_2
The following indexes appear to be equal and one of them should be removed: PRIMARY, comment_ID_2
The following indexes appear to be equal and one of them should be removed: comment_post_ID, comment_post_ID_2
The following indexes appear to be equal and one of them should be removed: comment_date_gmt, comment_date_gmt_2
The following indexes appear to be equal and one of them should be removed: comment_approved, comment_approved_2
The following indexes appear to be equal and one of them should be removed: PRIMARY, comment_ID
Reply With Quote
  #165  
Old 25th May 2009, 12:40
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by Tenaka View Post
trying to export from MySQL version 5.0.51 via as shown here: http://www.howtoforge.com/faq/6_3_en.html

can someone please explain what to use instead of this -c switch?

ok, seems the -c switch is obsolete, so I tried the replacement --skip-auto-rehash:



stil no go?
You might want to try the --opt switch.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #166  
Old 25th May 2009, 13:29
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,262
Thanks: 78
Thanked 24 Times in 20 Posts
Default

as in replacing the -c with --opt? don't have ssh access right now so I can't consult the man pages right now...
Reply With Quote
  #167  
Old 26th May 2009, 22:49
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

The --opt switch replaces multiple other switches. Please take a look at the man page.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #168  
Old 27th May 2009, 08:32
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,262
Thanks: 78
Thanked 24 Times in 20 Posts
Default

tried man mysql and gogling but nowhere is there an --opt switch mentioned...

seee here too: http://dev.mysql.com/doc/refman/5.0/...d-options.html
Reply With Quote
  #169  
Old 28th May 2009, 11:33
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Oh, sorry. The mysqldump command has an --opt switch...
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #170  
Old 15th June 2009, 21:31
kextra1 kextra1 is offline
Senior Member
 
Join Date: Apr 2008
Posts: 121
Thanks: 12
Thanked 10 Times in 6 Posts
 
Default Help!

I really screwed up guys

I messed up all my permissions from /

I am trying to move all ISPConfig data over to a new server

I followed the steps however the MySQL server does not start after following the moving ispconfig steps

Also, before the permissions got all screwed up on this server I backed up all the databases to 'Localhost.sql'

My new server does not have a graphics card....

How can I import all my databases from 'localhost.sql' into the new mysql server from the command line?

I'm not talking about one at a time...i backed them ALL up, ALL DB's to one sql dump

Last edited by kextra1; 15th June 2009 at 21:37.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot access ispconfig site Nu2Linux Installation/Configuration 13 3rd January 2009 15:29
Users and websites aren't created Glorfindel Installation/Configuration 9 23rd February 2006 04:20
42goISP vs. ISPConfig nveid General 1 16th January 2006 09:07
Mirroring ISPConfig with DRBD rodriglm General 5 2nd January 2006 12:48
Moving mail in ISPConfig rodriglm General 3 7th December 2005 09:44


All times are GMT +2. The time now is 02:09.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.