Skip to:
Content
Pages
Categories
Search
Top
Bottom

Test site question

  • @famous

    Participant

    I have a website that I am making changes to live and I have decided to create a test site in dreamweaver to stop annoying people by making changes live.

    It took forever, however I installed apache, php and mysql and now I have downloaded my database from the remote server and now I am trying to upload that database to my computer. However, I have had no luck.

    I just tried:

    mysql -u root – p DATABASE < nameOfSQLdatabase.sql

    &

    mysqldump -u root – p DATABASE < nameOfSQLdatabase.sql

    I got no error message it looks like it went through, but still no data?

    I have also tried connecting direct to my remote host from the test server and the homepage localhost.localdomain shows

    No WPMU site defined on this host. If you are the owner of this site, please check Debugging WPMU for further assistance.

    Can someone give insight as to how I can accomplish this? Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • @conceptfusion

    Participant

    I’d suggest installing phpMyAdmin locally and importing your database with that or you could use a desktop database management application like SQLYog.

    You’ll need to update any references to your live hosting url (domain.tld) in your SQL file to reference your local dev url (localhost.localdomiain).

    Also, if you’re running under Windows and have WPMU set to use sub-domains you’ll need to add entries for each subdomain in your hosts file manually.

    Andrea Rennick over at wpmututorials.com has just written a pdf ebook on installing MU that you might find helpful too.

    @famous

    Participant

    Thanks for your help…

    @conceptfusion

    Participant

    You could update the file size limit in your php.ini file although that will increase the upload limit globally, not just for phpMyAdmin.

    upload_max_filesize = 5M;

    memory_limit = 16M;

    A preferable approach might be to add an .htaccess file in your phpMyAdmin directory with the following directives:

    php_flag upload_max_filesize “5M”

    php_flag max_execution_time 300

    php_flag memory_limit “64M”

    This should increase your file upload size limit just for phpMyAdmin to 5Mb and allow for the extra execution time required.

    It’s worth noting that most sources suggest increasing php’s memory limit from the default 16Mb’s when using WordPress MU anyway so you might want to make that change in the php.ini rather than the .htaccess file.

    @conceptfusion

    Participant

    Sorry, those .htaccess directives might start with php_value rather than php_flag :-)

    @famous

    Participant

    Thanks for the help. I have one last question. How do I direct my httpd file to point to:

    home/USER/public_html

    instead of:

    C:Userstestetc…

    ???

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Test site question’ is closed to new replies.
Skip to toolbar