database not pushing

  • Resolved whomikey

    (@whomikey)


    11 years, 6 months ago

    i’m trying to push the database and the files but only the files are pushing. i tried to push “entire database” and then i tried one of the other options at a time to see if that would make a difference, and it didn’t. all of my files are pushing fine. there are no errors being displayed (i enabled SitePush debug). my push results are below:

    [1] Push started at Thu, 05 Sep 2013 19:44:47 +0000
[2] Database backup off
[1] Maintenance mode on
[3] RUN: echo "<?php \$upgrading=1378410287; ?>" > C:\wamp\www\wordpress.dev/.maintenance
[1] Pushing database tables from live to dev: --tables wp_links wp_postmeta wp_posts wp_term_relationships wp_term_taxonomy wp_terms
[2] Database source: live (wordpress) on localhost/wordpress
[2] Database dest: dev (wordpress.dev) on localhost/wordpress.dev
[3] RUN: C:/wamp/bin/mysql/mysql5.6.12/bin/mysqldump.exe --opt --verbose -u root -p'*****' wordpress --tables wp_links wp_postmeta wp_posts wp_term_relationships wp_term_taxonomy wp_terms | C:/wamp/bin/mysql/mysql5.6.12/bin/mysql.exe -D wordpress.dev -u root -p'*****'
[1] Maintenance mode off
[3] RUN: if [ -f "C:\wamp\www\wordpress.dev/.maintenance" ]; then rm "C:\wamp\www\wordpress.dev/.maintenance"; fi
[1] Push completed at Thu, 05 Sep 2013 19:44:47 +0000
[1] Push took 0.1874988079071 seconds

    [Please post log files between backticks or use the code button.]

    when i enable backup, the .sql file doesn’t save but an .undo file does. not sure if that gives you anymore clues.

    thanks!

    https://www.ads-software.com/plugins/sitepush/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Mark Rowatt Anderson

    (@markauk)

    From the info you posted, the command which is actually doing (or not) the copying from one DB to the other is:-

    C:/wamp/bin/mysql/mysql5.6.12/bin/mysqldump.exe --opt --verbose -u root -p'*****' wordpress --tables wp_links wp_postmeta wp_posts wp_term_relationships wp_term_taxonomy wp_terms | C:/wamp/bin/mysql/mysql5.6.12/bin/mysql.exe -D wordpress.dev -u root -p'*****'

    What happens if you try running that directly in a terminal window? You’ll need to replace the ***** with the correct passwords for each DB.

    If that doesn’t work then given the way the DB is being moved, i.e. piping from mysqldump to mysql (which is standard in linux type environments), may need to be done differently on Windows.

    Thread Starter whomikey

    (@whomikey)

    i set the password in the database config:

    [all]
    prefix = wp_

    [live]
    name = wordpress
    user = root
    pw = test

    [dev]
    name = wordpress.dev
    user = root
    pw = test

    you were right though, Windows doesn’t like something and it ended up being the forward slashes so i had to replace them with backslashes. C:\wamp\bin\mysql fixed that issue. now i’m getting the “ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)” and i know what it means but i set the passwords in the database config (code above) so i’m not sure why it would do that?

    thanks for all of your help so far! hopefully my issues can help other Windows users!

    Thread Starter whomikey

    (@whomikey)

    the issue with the password error has been resolved. it looks like single quotes are causing a problem with the password because the password is a variable. to fix this i edited your classes/class-sitepush-core.php file line 262 and line 263 changing the -p'{$db_source[‘pw’]}’ to -p{$db_source[‘pw’]}

    thank you for your help! the plugin is awesome now that i got it working! ??

    Plugin Author Mark Rowatt Anderson

    (@markauk)

    Thanks for following up and glad you got it fixed.

    The single quotes around the password that you changed aren’t because there’s a variable in there… those single quotes are from the shell command – the whole PHP expression is in double quotes so the variable will be inserted properly.

    It’s possible windows shell doesn’t like single quotes, or – did you have a single quote or any other non alphanumerics in the password?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘database not pushing’ is closed to new replies.