Moving ISPconfig

[wr19026]

Ok thanks. Not what I had hoped for but you can't have everything I guess

[esezako]

hi, the numbers of groups and users not match in my olds and news files passwd , shadow and group. What numbers should I keep?

[Ovidiu]

trying to export from MySQL version 5.0.51 via

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:

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?

[Ovidiu]

I tried exporting/importing via phpmyadmin as its a small DB but then I get this type of errors in every table:

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

[falko]

Originally Posted by Tenaka

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.

[Ovidiu]

as in replacing the -c with --opt? don't have ssh access right now so I can't consult the man pages right now...

[falko]

The --opt switch replaces multiple other switches. Please take a look at the man page.

[Ovidiu]

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

[falko]

Oh, sorry. The mysqldump command has an --opt switch...

[kextra1]

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