armandulis Posted October 1, 2008 Report Share Posted October 1, 2008 Uztaisīju caur FREEHOSTIA jaunu accountu, man tagad tajā datubāzē ko uztaisīju nav nekā. Exportoju datubāzes .sql failu no vecā accounta, tagad vajag iekšā datbūt jaunajā accountā lūdzu pasakiet, kā var ielikt to .sql failu iekš tās jaunās datubāzes. Link to comment Share on other sites More sharing options...
RMXjunior Posted October 1, 2008 Report Share Posted October 1, 2008 Nu lieto tā hosta piedāvāto SQL adminēšanu .. piem kāphpmyadmin, jābūt kkam līdzīgam.. Link to comment Share on other sites More sharing options...
armandulis Posted October 1, 2008 Author Report Share Posted October 1, 2008 Es tak tur eju, bet īsti nezinu kurā sadaļā un kas jādara lai to sql failu ieliktu. Link to comment Share on other sites More sharing options...
RMXjunior Posted October 1, 2008 Report Share Posted October 1, 2008 Ja lieto PhpMyAdmin tad: 1. Atver bāzi 2. Augšā kur ir Browse, Structure, SQL, Search, Insert utt.. Paņem Import 3. Spied browse un paņem savu .sql failu 4. Labajā apakšējā stūri spied Go Link to comment Share on other sites More sharing options...
armandulis Posted October 1, 2008 Author Report Share Posted October 1, 2008 Kaut kāds murgs...ielieku, bet rāda erroru: SQL query: -- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- http://www.phpmyadmin.net -- -- Host: mysql4.freehostia.com -- Generation Time: Oct 01, 2008 at 02:01 PM -- Server version: 4.1.11 -- PHP Version: 5.2.0-8+etch9~bpo31+1 -- -- Database: `aaaaaa505_ak` -- CREATE DATABASE `aaaaaa505_ak` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci MySQL said: Documentation #1044 - Access denied for user 'necgam6_nec'@'%' to database 'aaaaaa505_ak' Link to comment Share on other sites More sharing options...
Norek Posted October 1, 2008 Report Share Posted October 1, 2008 MySQL said: Documentation #1044 - Access denied for user 'necgam6_nec'@'%' to database 'aaaaaa505_ak' lasīt māki ? tādam lietotājam nav tiesību veidot datubāzi. that`s it! Link to comment Share on other sites More sharing options...
armandulis Posted October 1, 2008 Author Report Share Posted October 1, 2008 kā tad lai es ielieku to .sql failu iekš datubāzes? Link to comment Share on other sites More sharing options...
brazer Posted October 1, 2008 Report Share Posted October 1, 2008 atver to .sql failu ieej phpmyadmin tajā panelī uzspied augšā SQL lieliem burtiem rakstīts,iekopē to tekstu tur. Link to comment Share on other sites More sharing options...
RMXjunior Posted October 1, 2008 Report Share Posted October 1, 2008 Tikai padzēs CREATE DATABASE `aaaaaa505_ak` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci, jo cik es sapratu datubāze tev jau tika piešķirta. Link to comment Share on other sites More sharing options...
armandulis Posted October 2, 2008 Author Report Share Posted October 2, 2008 To rindu izdzēsu, bet ieliekas tikai dažas tabulas (98) nevis kādas ~600. jo man tur IPB postus , lietotājus vajag arī atpakaļ. Link to comment Share on other sites More sharing options...
RMXjunior Posted October 2, 2008 Report Share Posted October 2, 2008 Varbūt tur ir kāds limits priekš viena sql querija.. Pamēģini sadalīt savu .sql failu vairākās daļās un tad vienu pēc otras pievienot caur phpmyadmin ar copy/paste Link to comment Share on other sites More sharing options...
armandulis Posted October 2, 2008 Author Report Share Posted October 2, 2008 skaidrs, kā tad var izdzēst visas tabulas nevis dzēšot pa vienai? Link to comment Share on other sites More sharing options...
RMXjunior Posted October 2, 2008 Report Share Posted October 2, 2008 Tur pat kur ir SQL, Import, Browse utt.. ir DROP Link to comment Share on other sites More sharing options...
Norek Posted October 2, 2008 Report Share Posted October 2, 2008 600 tabulas ? omg, Tev tur kas ir, visa mūža darbi ? man vidēji uz vienu projektu ir 70 tabulas. kā var uzturēt 600 ?! cik tad Tev liels tas sql, jo importam ir limits? Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now