Split SQL file into 1 per a table.

[sambauers]

Split SQL file into 1 per a table.

[sambauers]

Hi there! I'm a bit perplexed, the script does this by default already. What are you trying to achieve? Maybe I can help.

[CrandellWS]

I was reading through the script and i thought that it split the sql per
database not per table... Let me look again or can you point to where this
happens in the script...

On Wed, Feb 19, 2014 at 12:58 AM, Sam Bauers [email protected]:

Hi there! I'm a bit perplexed, the script does this by default already.
What are you trying to achieve? Maybe I can help.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/3#issuecomment-35468805
.

[CrandellWS]

I missed the for statement mybad...
After reading line 312 all I got is Thanks.

On Wed, Feb 19, 2014 at 1:33 AM, William Crandell [email protected]:

I was reading through the script and i thought that it split the sql per
database not per table... Let look again or can you point to where this
happens in the script...

On Wed, Feb 19, 2014 at 12:58 AM, Sam Bauers [email protected]:

Hi there! I'm a bit perplexed, the script does this by default already.
What are you trying to achieve? Maybe I can help.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/3#issuecomment-35468805
.

[CrandellWS]

Hey Sam,

I don't know if you knew this or not but your script will not work with
Godaddy shared hosting customers on premium accounts. This is a 2 sided
issue, well actually it is just Godaddy's setup, so you can cater to it or
not.

Godaddy's system requires the MySql password to have at least 1 symbol. It
has to be one of these !@#%

If one has set a password to use one of these 3 symbols !#% then you can
not access the MySql command via scripting, one would have to use the @
symbol. (though I will have to check on mysqldump, I believe this is more
flexible on this note, let me know if you want absolute information on that
part) I am using both commands as you will see in the example shell script.

Additionally with Godaddy you can not use the -p flag, you have to use the
--password instead. It was a pain to get the first successful connection
with the simple and short shell script I attached.

Let me know if i can be further help on this manner.

William

On Wed, Feb 19, 2014 at 1:39 AM, William Crandell [email protected]:

well then after reading line 312 all I got left is thanks for your time.

On Wed, Feb 19, 2014 at 1:35 AM, William Crandell [email protected]:

I missed the for statement mybad...

On Wed, Feb 19, 2014 at 1:33 AM, William Crandell [email protected]:

I was reading through the script and i thought that it split the sql per
database not per table... Let look again or can you point to where this
happens in the script...

On Wed, Feb 19, 2014 at 12:58 AM, Sam Bauers [email protected]:

Hi there! I'm a bit perplexed, the script does this by default already.
What are you trying to achieve? Maybe I can help.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/3#issuecomment-35468805
.

#!/bin/bash

timeStamp=$(date +%m-%d-%Y@%T)

#mysqldump command and options
msdOPTS=" mysqldump"
msdOPTS="${msdOPTS} --skip-opt"
msdOPTS="${msdOPTS} --single-transaction"
msdOPTS="${msdOPTS} --add-drop-table"
msdOPTS="${msdOPTS} --create-options"
msdOPTS="${msdOPTS} --quick"
msdOPTS="${msdOPTS} --extended-insert"
msdOPTS="${msdOPTS} --set-charset"
msdOPTS="${msdOPTS} -h mydbname.db.01234567.hostedresource.com"
msdOPTS="${msdOPTS} -u mydbname"
msdOPTS="${msdOPTS} --password=pass@adsf1@lGgmTh"
msdOPTS="${msdOPTS} mydbname"

#mysql line command and options
msOPTS="${msOPTS} mysql"
msOPTS="${msOPTS} --user myotherdbname"
msOPTS="${msOPTS} -h myotherdbname.db.01234568.hostedresource.com"
msOPTS="${msOPTS} --password=pass@adsf1@Hasd" #will be required to user at least 1 symbol
msOPTS="${msOPTS} myotherdbname"

$msdOPTS | $msOPTS

$msdOPTS > db_backups/mysql_$timeStamp.sql

[CrandellWS]

You may want to have a look at this help doc they posted about mysql and
ssh access

http://support.godaddy.com/help/article/7588/importing-mysql-databases-via-ssh

On Wed, Feb 19, 2014 at 8:59 PM, William Crandell [email protected]:

Hey Sam,

I don't know if you knew this or not but your script will not work with
Godaddy shared hosting customers on premium accounts. This is a 2 sided
issue, well actually it is just Godaddy's setup, so you can cater to it or
not.

Godaddy's system requires the MySql password to have at least 1 symbol. It
has to be one of these !@#%

If one has set a password to use one of these 3 symbols !#% then you can
not access the MySql command via scripting, one would have to use the @
symbol. (though I will have to check on mysqldump, I believe this is more
flexible on this note, let me know if you want absolute information on that
part) I am using both commands as you will see in the example shell script.

Additionally with Godaddy you can not use the -p flag, you have to use the
--password instead. It was a pain to get the first successful connection
with the simple and short shell script I attached.

Let me know if i can be further help on this manner.

William

On Wed, Feb 19, 2014 at 1:39 AM, William Crandell [email protected]:

well then after reading line 312 all I got left is thanks for your time.

On Wed, Feb 19, 2014 at 1:35 AM, William Crandell [email protected]:

I missed the for statement mybad...

On Wed, Feb 19, 2014 at 1:33 AM, William Crandell [email protected]:

I was reading through the script and i thought that it split the sql
per database not per table... Let look again or can you point to where this
happens in the script...

On Wed, Feb 19, 2014 at 12:58 AM, Sam Bauers [email protected]:

Hi there! I'm a bit perplexed, the script does this by default
already. What are you trying to achieve? Maybe I can help.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/3#issuecomment-35468805
.

[CrandellWS]

So Godaddy has ended the ability...

[CrandellWS]

now --password is not usable

[sambauers]

I'm not going to tweak the script to satisfy the peculiarities of a particular provider, sorry.